Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 17277 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dynamic cache?
What is a repository manager?
What is rank transformation?
What are the types of caches in lookup?
How can we store previous session logs?
Which is the t/r that builts only single cache memory?
How to use pmcmd utility command?
How many ways are there to create ports?
How an expression transformation differs from aggregator transformation?
Define mapping and session?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the guidelines to be followed while using union transformation?
What is the maplet?
In development project what is the process to follow for an etl developer from day1
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
