Informatica - What is meant by source is changing incrementally?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 607 of 644

What is meant by source is changing incrementally?

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

Total Answers and Comments: 3

Last Update: April 14, 2008 Asked by: tanya123

Sponsored Links

Best Rated Answer

—

Submitted by: Vani_AT

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.

Above answer was rated as good by the following members:
avneeshrathor

February 29, 2008 13:10:16

garunchowdary

Member Since: February 2008 Contribution: 6

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

Is this answer useful? Yes | No

March 28, 2008 04:21:11

Vani_AT

Member Since: December 2007 Contribution: 16

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 14, 2008 08:15:10

N SRIRAM K

Member Since: May 2007 Contribution: 115

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....

Thx
SRIRAM N

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank