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

Showing Answers 1 - 3 of 3 Answers

prasad.yandapalli

  • Aug 10th, 2006
 

we use stored procedure for populating and maintaing databases in our mapping

  Was this answer useful?  Yes

mahesh17375

  • Aug 15th, 2006
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions