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

Advance Thanks,
Manojkumar

Answer Posted / rayudu

One more thing is while loading the data into table
,informatica writes the data into database logs before
loading into target ,and this cant be done while loading a
flat file.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enterprise data warehouse your projects phase by phase explain?

1678


Different circumstance which drives informatica server to expel records?

743


How do you use reject loader.

2331


Can we create a Integration service without a Repository service and vice versa?

995


What are the mapping parameters and mapping variables?

836


Where do we use mapping variables in informatica?

817


What are the components of the workflow manager?

898


What is the commit type if you have a transaction control transformation in the mapping?

842


Where can we find the throughput option in informatica?

848


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

7134


How many types of sessions are there in informatica.please explain them?

939


What are the tuning techniques you applied during your last project

1790


Define update strategy?

830


Write the advantages of partitioning a session?

1000


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2542