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
What is workflow? What are the components of the workflow manager?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is dimensional table?
What is xml source qualifier transformation in informatica?
how to load dimension table and fact table. plz tell me the steps.
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 ?
What is a shortcut and copy in Informatica and how two are different with each other?
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
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the informatica performance improvement tips
Enlist the various types of transformations.
Explian the Process of deployment groups in informatica
What is a repository? And how to add it in an informatica client?
What is the difference between informatica 7.0 and 8.0?
Can we override a native sql query within informatica?