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

Advance Thanks,
Manojkumar

Answer Posted / joe

In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain transaction control transformation in informatica

908


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

1232


Is it possible to revert a global repository to local one and why?

715


What does role playing dimension mean?

714


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

751






Which development components of informatica have the highest usage?

693


Is it possible to create multiple domains on a single Informatica server?

866


How to create or import flat file definition in to the warehouse designer?

718


What is substr in informatica?

789


Is stop and abort are same in informatica?

657


How to join three sources using joiner? Explain though mapping flow.

780


Can u generate reports in Informatica?

731


Explain the code page compatibility?

730


wf dont have integration severances how you can run?

1617


What is the status code in stored procedure transformation?

765