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

Advance Thanks,
Manojkumar

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

904


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2097


What is dimensional table?

839


What is xml source qualifier transformation in informatica?

985


how to load dimension table and fact table. plz tell me the steps.

1890


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1438


What is a shortcut and copy in Informatica and how two are different with each other?

961


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1849


How do you remove duplicate records in informatica? And how many ways are there to do it?

930


What are the informatica performance improvement tips

856


Enlist the various types of transformations.

770


Explian the Process of deployment groups in informatica

848


What is a repository? And how to add it in an informatica client?

924


What is the difference between informatica 7.0 and 8.0?

775


Can we override a native sql query within informatica?

847