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


Please Help Members By Posting Answers For Below Questions

While migrating the data from one environment to another environment how would you manage the connections?

876


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1375


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1936


What is a sorter transformation?

884


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9372


wf dont have integration severances how you can run?

1722


What is the scenario which compels informatica server to reject files?

833


In informatica workflow manager, how many repositories can be created?

1038


Explain target update override in informatica

847


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1808


How to elaborate tracing level?

897


what is SDLC way of code development?

1771


What's the layout of parameter file (what does a parameter file contain?)?

2178


Write the unconnected lookup syntax and how to return more than one column.

839


How can we use mapping variables in informatica? Where do we use them?

838