Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / ranjan
One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
Do you find any difficulty while working with flat files as source and target?
What is lookup transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are Dimensional table?
What is a sorter transformation?
Informatica settings are available in which file?
Explain sessions. Explain how batches are used to combine executions?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to do unit testing in informatica? How to load data in informatica ?
Explain the scenario which compels informatica server to reject files?
What is aggregator transformation in informatica?
What are the measure objects?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is rank transformation?