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
What is a sequence generator transformation?
Does an informatica transformation support only aggregate expressions?
Describe expression transformation?
What are the components of workflow manager?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Performance tuning in UNIX for informatica mappings?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is a passive transformation?
What is the use of code page?
How do you load only null records into target? Explain through mapping flow.
What is informatica? Why do we need it?
What is a surrogate key?
What is confirmed fact in dataware housing?
What is the difference between router and filter?
What is a difference between complete, stop and abort?