Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 15779 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Enlist few areas or real-time situations where informatica is required.
What is the need for an etl tool?
Explain the etl program with few examples.
What are the mapping parameters and mapping variables?
Partition, what happens if the specified key range is shorter and longer
Define enterprise data warehousing?
How does a rank transform differ from aggregator transform functions max and min?
Explain sessions. Explain how batches are used to combine executions?
What are the different versions of informatica?
What are the various types of transformation?
Separate from a database, an information bazaar, and an information stockroom?
What are the reusable transformations?
What is blocking transformation?
Enlist the advantages of informatica.
