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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What can we do to improve the performance of informatica aggregator transformation?
How can you validate all mappings in the repository simultaneously?
What is target load order?
Differentiate between router and filter transformation?
If informatica has its scheduler why using third party scheduler?
What does cheating measurement mean?
What are the types of presistent cache in look up tr.
EXL informatica Questions
What is an expression transformation?
What is a sorter transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How can we store previous session logs?
How to configure mapping in informatica?