Prev: Create non-existing columns
Next: graphs in a report
From: Maurice on 7 Jul 2010 05:31
I am using the SCD type 2 loader in Data Integration Studio. I have
some type 2 columns but also some type 1. I marked this type 1 columns
in the 'Type 1 Columns tab', but when I load a new row with a new
value for this columns it only updates the last row for the matching
Business Key and not for all rows of thet Business Key. This looks to
me like incorrect behaviour. I could not find anything to change this.

So I have currently the following row in the target dimension table

ProductSkey=1;
ProductName(BusinessKey)='Shoes';
ProductDescription(SCD type 1 and selected in the 'Type 1 Columns'
tab)='Made for walking';
ProductPrice(SCD type 2 and selected in the 'Detect changes' tab)=10;
Date=1JAN2001;

If I load the following using the CSD type 2 Loader

ProductName(BusinessKey)='Shoes';
ProductDescription(SCD type 1)='Made for running';
ProductPrice(SCD type 2)=20;
Date=2JAN2001;

I get a new row because of the change ProductPrice which is correct.
But the problem is that in the first row the value for
ProductDescription is still 'Made for walking', while I expect it to
be also Made for running? I do not think this is correct behaviour or
am I wrong or is there some easy way to do it?



 | 
Pages: 1
Prev: Create non-existing columns
Next: graphs in a report