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
Can u generate reports in Informatica?
What is repository manager?
What is decode in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is informatica metadata and where is it stored?
Explain the use of aggregator cache file?
On which transformations you created partitions in your project?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What happens when a session fails and you click on recover?
What are the new features of informatica 9.x in developer level?
Explain sessions?
if we have a delimiters at unwanted places in a flat file how can we over come those.
As union transformation gives UNION ALL output, how you will get the UNION output?
Differences between connected and unconnected lookup?
have u done any performance tuning? how u ll do?