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
Informatica settings are available in which file?
Differentiate between sessions and batches?
Define mapping and session?
What is the command used to run a batch?
What is DR strategy for Informatica project?
Explain what transformation and how many are there in informatica?
What are the different types of repositories created using informatica?
what is index?how it can work in informatica
What are the different versions of informatica?
On which transformations you created partitions in your project?
how to load rows into fact table in data warehouse
What is a repository manager?
What is the need for an etl tool?
What are the components of the workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how