Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
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
Slowly changing dimensions, types and where will you use them
Explain how many types of dimensions are available in informatica?
What is the need for an etl tool?
How do you set a varible in incremental aggregation
What are the differences between joiner transformation and source qualifier transformation?
What is the cumulative sum and moving sum?
What are the new features of informatica 9.x at the developer level?
Enlist the tasks for which source qualifier transformation is used.
Explain in detail about scd type 1 through mapping.
Design a mapping to load the cumulative sum of salaries of employees into target table?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
what is song in infrmatica...?
How can you define user defied event?
What are the features of complex mapping?
Difference between Data and Index Caches?