RE: What is meant by source is changing incrementally?
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
RE: What is meant by source is changing incrementally?
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.
RE: What is meant by source is changing incrementally?
The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....
