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 is a surrogate key?
What all join we can perform in LOOKUP transformation?
Define the various join types of joiner transformation?
Explain the difference between mapping parameter and mapping variable?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is parallel processing in informatica?
Describe expression transformation?
Why union transformation is an active transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Describe an informatica powercenter?
can u give example for factless fact table
Explain what transformation and how many are there in informatica?
What are the different ways to implement parallel processing in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance