Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / suresh
Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.
But where as records from flat files are copied in easier way
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe data concatenation?
What is Index Caches size?
How you prepared reports for OLAP?
Enlist the tasks for which source qualifier transformation is used.
Differentiate between Load Manager and DTM?
How many ways are there to do 'remove duplicate records in informatica'?
what is SDLC way of code development?
What do you mean by channel change?
What is an expression transformation?
Explain scd type 3 through mapping.
Why is sorter an active transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Global and Local shortcuts. Advantages.
What is data caches/ index caches?
According to his methodology what all you need before you build a datawarehouse