To write data in table informatica server generate the insert statement for

Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar

Question Posted / nidhi

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

Please Help Members By Posting Answers For Below Questions

What is the cumulative sum and moving sum?

1135

can u give example for factless fact table

6441

where to store informatica rejected data?

1046

What does cheating measurement mean?

995

Enterprise data warehouse your projects phase by phase explain?

1856

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

1046

what is the hint? how to use it to reduce the query processing in program?

7627

what is the -ve test case in your project.

2329

What are the measure objects?

1118

How to generate or load values in to the target table based on a column value using informatica etl tool.

1016

Differentiate between sessions and batches?

962

How to open an older version of an object in the workspace?

1126

how many types of dimensions are available in informatica?

997

Can we get 1st record through Informatica(without sequence number).

1406

what is diff b/t sorter t/r and agg have the option sorter property...

2129