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

How to create the source and target database connections in server manager?

850


How to update a particular record in target with out running whole workflow?

1376


Can anyone tell me the new features in Informatica 9 Version?

1805


Briefly define a session task?

829


Define pmcmd command?

823


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2217


What is a connected transformation?

889


Explain scd type 3 through mapping.

781


Explain sql transformation in script mode examples in informatica

820


How to generate sequence numbers?

840


Explain sessions and how many types of sessions are there?

810


how to load rows into fact table in data warehouse

915


Can informatica load heterogeneous targets from heterogeneous sources?

961


Differentiate between a repository server and a powerhouse?

808


What do you understand by term role-playing dimension?

800