In Update Strategy Target Table Orflat File Which Gives More Performa

1.	In Update Strategy Target Table Orflat File Which Gives More Performance ? Why?
Answer» Pros: LOADING, SORTING, Merging OPERATIONS will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat FILE. As there is no indexes, while LOOKUPS speed will be lesser. Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file. As there is no indexes, while lookups speed will be lesser.

In Update Strategy Target Table Orflat File Which Gives More Performance ? Why?

Answer»

Pros: LOADING, SORTING, Merging OPERATIONS will be faster as there is no index concept and Data will be in ASCII mode.

Cons: There is no concept of updating existing records in flat FILE.

As there is no indexes, while LOOKUPS speed will be lesser.

Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode.

Cons: There is no concept of updating existing records in flat file.

As there is no indexes, while lookups speed will be lesser.