Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 17288 Views
- IBM, I also Faced
- E-Mail Answers
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 is union transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Briefly explain the aggregator transformation?
What is the maplet?
What is an aggregator transformation?
How to load data in informatica ?
How to improve the performance of a session using sorter transformation?
What is sequence generator transformation in informatica?
What is the need of an ETL tool?
What is the reusable transformation?
What are the new features of Power Center 5.0?
What are the types of data warehouses?
What are the tasks that can be performed using sq?
What are the designer tools for creating transformations?
What is a transaction control transformation?
