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 update strategy transform?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the advantages of informatica?
Explain joiner transformation in informatica
What is the use of code page?
Explain transaction control transformation in informatica
Explain what transformation and how many are there in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
Explain the code page compatibility?
Can we override a native sql query within informatica?
Does an informatica transformation support only aggregate expressions?
What are the different versions of informatica?
What is exclusive and normal mode for repository services?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Implementation methodology