Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 17445 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
What is Index Caches size?
How to open an older version of an object in the workspace?
How do we call shell scripts from informatica?
What are the advantages of informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the different components of powercenter?
How can we delete duplicate rows from flat files?
What do mean by local and global repository?
What are the limitations of joiner transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Define Pmrep command?
What all join we can perform in LOOKUP transformation?
What is flashback table ? Advance thanks
Can anyone tell me the new features in Informatica 9 Version?
