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
Differentiate between sessions and batches?
What is the difference between source qualifier transformations source filter to filter transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Write the unconnected lookup syntax?
What is resilience time?
What are active and passive transformations?
What is the function of look up transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is Data Caches size?
What is lookup transformation?
Performance tuning( what you did in performance tuning)
How does a sorter cache works?
Explain the scenario which compels informatica server to reject files?
What is decode in static cache?
While migrating the data from one environment to another environment how would you manage the connections?