Data WareHouse & Informatica Interview Questions & answers Update
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