What is meant by source is changing incrementally?

What is meant by source is changing incrementally?
Explain with an example?

Questions by tanya123   answers by tanya123

Showing Answers 1 - 9 of 9 Answers

I guess your question is related to Slowly Changing Dimensions(SCDs)!!
If you take an ex that there is an object called X,the price of X in 2005 is 10,in 2006 is 20,in 2007 is 30 and now it is 40,so along with time, the price is changing, so whenever if we want to capture all these changes,we go for SCDs.
There are 3 types of SCDs:
1)Current Information:we just update the current price
2)History:all the previous prices and the current price
3)Partial History:just the price in 2007 and 2008 i.e., previous and the present

  Was this answer useful?  Yes

Vani_AT

  • Mar 28th, 2008
 

I think, source is changing incrementally means new rows are getting inserted into the source. For example, If a source on day1 has 10 records; then on day2, 5 new records got added along with the previous day's 10 records, so total 15 records come on day2; lets assume 7 reocrds got added on day3, then there will be total 22 records coming on day3; and so on.
In nutshell, the previous day's data remain unchanged and new data gets inserted in the source.

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