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
Describe expression transformation?
What are the databases that informatica can connect to windows?
How would you join a node to the already existing domain?
What is the command used to run a batch?
Enlist the various types of transformations.
What you know about transaction control transformation?
Performance tuning in UNIX for informatica mappings?
Explain how to import oracle sequence into informatica?
What is a repository? And how to add it in an informatica client?
What is an aggregator transformation?
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??
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to extract the informatica rejected data?
What is the difference between router and filter?
To import the flat file definition into the designer where should the flat file be placed?