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


Please Help Members By Posting Answers For Below Questions

What is update strategy transform?

841


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?

853


What are the advantages of informatica?

785


Explain joiner transformation in informatica

912


What is the use of code page?

818


Explain transaction control transformation in informatica

1067


Explain what transformation and how many are there in informatica?

734


How many ways are there to do 'remove duplicate records in informatica'?

809


Explain the code page compatibility?

866


Can we override a native sql query within informatica?

848


Does an informatica transformation support only aggregate expressions?

835


What are the different versions of informatica?

979


What is exclusive and normal mode for repository services?

926


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

940


Implementation methodology

1511