Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / rayudu
hi,
Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.
Regards,
rayudu.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are data-driven sessions?
How is union transformation utilized?
How can we use mapping variables in informatica? Where do we use them?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain what is informatica metadata and where is it stored?
Why sorter is an active transformation?
What are Dimensional table?
Write the prerequisite tasks to achieve the session partition?
What is repository manager?
can we override a native sql query within informatica? Where do we do it?
Briefly describe lookup transformation?
Name the different lookup cache(s)?
Where are the source flat files kept before running the session?
can anyone suggest best free Talend data integration training online
How you can differentiate between connected lookup and unconnected lookup?