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 are the components of Informatica? And what is the purpose of each?
What is joiner transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a grid in Informatica?
What are session parameters ? How do you set them?
What could be the possible resons of locks by user?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the status code in stored procedure transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the advantages of informatica.
Explain joiner transformation in informatica
What are the different versions of informatica?
What is the need of an ETL tool?
What are the different options available for update strategy?
What is the function of union transformation?