How do you maintain Historical data and how to retrieve the historical data?

Questions by krishnareddysw

Showing Answers 1 - 9 of 9 Answers

ravi

  • Oct 23rd, 2007
 

by using update statergy transformations

  Was this answer useful?  Yes

Thananjayan

  • Nov 17th, 2007
 

You can maintain the historical data by desing the mapping using Slowly changing dimensions types.

If you need to insert new and update old data,best go for Update strategy.

If you need to maintain the histrory of the data,for ex,The cost of the product change happen frequently,but you would like to maintain all the rate history,go to SCD Type2.

The design change as per your requirement.If you make your question more clear,I can provide your more information.

Cheers
Thana

  Was this answer useful?  Yes

kvrp461

  • Aug 13th, 2010
 

In SCD Type2 we want to maintain the historical as well as current data.
By using surrogate key or sequence generated key to maintain this historical data on to the target tables.

  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