In update strategy target table or flat file which gives more performance ? why?





Pros: Loading, Sorting, Merging operations will be faster as there is no indexconcept and Data will be in ASCII mode.
Cons: There is no concept of updating existingrecords in flat file.
As there is no indexes, while lookups speed will be lesser.

No comments:

Post a Comment