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
While migrating the data from one environment to another environment how would you manage the connections?
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.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a sorter transformation?
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?
wf dont have integration severances how you can run?
What is the scenario which compels informatica server to reject files?
In informatica workflow manager, how many repositories can be created?
Explain target update override in informatica
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. ?
How to elaborate tracing level?
what is SDLC way of code development?
What's the layout of parameter file (what does a parameter file contain?)?
Write the unconnected lookup syntax and how to return more than one column.
How can we use mapping variables in informatica? Where do we use them?