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


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

699


What are the differences between a connected lookup and unconnected lookup?

720


How can we use batches?

686


What is powercenter on grid?

813


What is a filter transformation and why it is an active one?

654






what is the Default Source Option For Update Strategy Transformation?

853


What are the settings that you use to configure the joiner transformation?

686


what is informatica metadata?

692


What is parallel processing in informatica?

1153


What is fact table? Explain the different kinds of facts.

691


What is the Rank index port in Rank transformation?

759


How to use procedural logic inside infromatica?

731


what is song in infrmatica...?

1811


What does reusable transformation mean?

755


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.

748