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 / lakshman

Hi,
one more thing flat file is a ODBC whn compare to others

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

What are the tuning techniques you applied during your last project

0 Answers  


What is the procedure to load the fact table.Give in detail?

1 Answers  


3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,


Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,


What are the session parameters?

3 Answers  






What is workflow? What are the components of workflow manager?

0 Answers  


What do you mean by filter transformation?

0 Answers  


What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  


What are conformed dimensions?

1 Answers  


difference between repository database and repository service?

0 Answers  


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


Categories