Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / nidhi
To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can we create multiple integration service on single repository?
What do you understand by SOA of Informatica?
How to do unit testing in informatica?
Explain what is informatica metadata and where is it stored?
Explain Dataware house architecture .how data flow from intial to end?
Which files are created during the session rums by informatics server?
How to generate sequence numbers?
What is the difference between router and filter?
While migrating the data from one environment to another environment how would you manage the connections?
Briefly define a session task?
How can we handle two sessions in informatica?
What is main use of mapplet?
How we can create indexes after completing the load process?