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 meant by a domain?

1122

Explain the different kinds of facts.

978

What are the differences between source qualifier and joiner transformation?

1056

What is the session task and command task?

1052

What does “tail –f” command do and what is its use as an Informatica admin.

1101

What is union transformation in informatica?

1144

How we can create indexes after completing the load process?

1156

Mention a few design and development best practices for informatica?

994

how we can load rejected record's at run time?(not through bad files)

2374

Tell me about Propagate functions in informatica

919

How might one distinguish in the case of mapping is right or not without associating session?

1105

What is Cognos script editor?

4225

What are the types of caches in lookup?

1048

Parameter and variable differences

2056

Explain constraint based loading in informatica

1091