Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / 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 |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
What are the differences between a connected lookup and unconnected lookup?
How can we use batches?
What is powercenter on grid?
What is a filter transformation and why it is an active one?
what is the Default Source Option For Update Strategy Transformation?
What are the settings that you use to configure the joiner transformation?
what is informatica metadata?
What is parallel processing in informatica?
What is fact table? Explain the different kinds of facts.
What is the Rank index port in Rank transformation?
How to use procedural logic inside infromatica?
what is song in infrmatica...?
What does reusable transformation mean?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.