Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar

Answers were Sorted based on User's Feedback



Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / rayudu

One more thing is while loading the data into table
,informatica writes the data into database logs before
loading into target ,and this cant be done while loading a
flat file.

Is This Answer Correct ?    7 Yes 1 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / rayudu

hi,


Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.



Regards,
rayudu.

Is This Answer Correct ?    4 Yes 1 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / joe

In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.

Is This Answer Correct ?    3 Yes 0 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / rayudu

another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.

Is This Answer Correct ?    3 Yes 1 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / ranjan

One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.

Is This Answer Correct ?    2 Yes 2 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / suresh

Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.

But where as records from flat files are copied in easier way

Is This Answer Correct ?    0 Yes 0 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / nidhi

To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.

Is This Answer Correct ?    0 Yes 0 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / ankur saini er.ankur861@gmail.

Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.

Is This Answer Correct ?    0 Yes 0 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / sanjay

While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.

Is This Answer Correct ?    0 Yes 0 No

Why do flat file load is faster if you compare that with table load ? Please answer me. Adva..

Answer / manojkumar

Thanks Rayudu.

Is there any other reson why flat file load is faster than
table load.

I had an interview and even I said the same answer. But the
interviewer asked me "Is there any other reason ?" .
Interviewer didn't satisfied with this answer.

I hope there will be some other reason as well for this
question.
Anyways thanks for your reply.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


When you move from devel to prod how will you retain a variable

1 Answers  


What are the various types of transformation?

0 Answers  


What are junk dimensions?

0 Answers  


what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,






Types of error logs in Informatica?

2 Answers  


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,


how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


what is diff between grep and find

3 Answers   IBM, iFlex,


in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


Categories