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

Advance Thanks,
Manojkumar

Answer Posted / rayudu

another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe expression transformation?

876


What are the databases that informatica can connect to windows?

809


How would you join a node to the already existing domain?

914


What is the command used to run a batch?

782


Enlist the various types of transformations.

748


What you know about transaction control transformation?

766


Performance tuning in UNIX for informatica mappings?

2346


Explain how to import oracle sequence into informatica?

785


What is a repository? And how to add it in an informatica client?

914


What is an aggregator transformation?

841


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

790


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

848


How to extract the informatica rejected data?

1002


What is the difference between router and filter?

847


To import the flat file definition into the designer where should the flat file be placed?

849