Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / rayudu
another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What do mean by local and global repository?
what is unit testing?tell me proceedure
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain the features of connected and unconnected lookup.
Explain the code page compatibility?
Explain the difference between a data warehouse and a data mart?
COM components can be used in Informatica
Can we create a Integration service without a Repository service and vice versa?
Is it possible to create multiple domains on a single Informatica server?
Why union transformation is an active transformation?
How to partition the Session?
What are the data movement modes in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain why we use partitioning the session in informatica?
what are 3 tech challenges/ common issues you face?