March 19, 2012 at 12:41 am
I am using scd to maintain type 1 and type 2.but i m getting weird result.CREATE TABLE source (ID IDENTITY(1,1),name nvarchar(10),code,code1)
insert into source values('j',123,123),('k',321,321)
CREATE TABLE dest(ID IDENTITY(1,1),name nvarchar(10),code,code1,strdate datetime,enddate datetime)
insert into dest values('j',123,123),('k',321,321)
so now i want type2 on name column and type1 on code and i am using code1 as business key .and for
that i am using SCD.i am getting weird result for e.g right now in dest i have 2 rows which is same as source
so if i will use type2 on name and type1 on code.even i am not changing anything in any column it is loading same ,data
into destination means after executing package i will have 4 rows in dest and if i would execute it again my
dest would have 6 rows and so on ,even if i am not chaging anything.but i will use type 1 on all columns it is working
properly .whenever i try to use type2 on any column it starts loading same data again and again.so please try to provide me a solution .
March 19, 2012 at 1:01 am
How did you implement the SCD?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 19, 2012 at 1:27 am
i am using code1 as business key ,name as type 2 and code as type 1 .
March 19, 2012 at 1:28 am
weston_086 (3/19/2012)
i am using code1 as business key ,name as type 2 and code as type 1 .
I mean, did you implement it using TSQL or using the SCD component in SSIS, or did you use a 3rd party component?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 19, 2012 at 9:21 am
using slowly changing dimension transformation in ssis.
March 19, 2012 at 1:35 pm
weston_086 (3/19/2012)
using slowly changing dimension transformation in ssis.
If rows are loaded into the destination while they are actually updates, there's probably something wrong in your configuration.
Check the conditions and if everything is mapped correctly.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 19, 2012 at 1:41 pm
Check this out: http://www.bimonkey.com/2010/05/an-sql-alternative-to-the-scd/
Jared
CE - Microsoft
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply