scd stage
Posted: Thu Jan 28, 2010 12:48 pm
Hi,
I have two recordss in source but in target i am getting 3records.sorce is dataset and refrence ,target are single table.i used scd stage for implementing scd2.
my source is like
custid custcrg custnm
100 aaa ibm
101 bbb csc
in taget i am getting like this
custsurid custid custcrg custnm effdt enddt
1 100 aaa ibm 2010-01-28 2020-12-31
0 2020-01-29
2 100 bbb csc 2010-01-28 2020-12-31
Thanks in adavance
.....
I have two recordss in source but in target i am getting 3records.sorce is dataset and refrence ,target are single table.i used scd stage for implementing scd2.
my source is like
custid custcrg custnm
100 aaa ibm
101 bbb csc
in taget i am getting like this
custsurid custid custcrg custnm effdt enddt
1 100 aaa ibm 2010-01-28 2020-12-31
0 2020-01-29
2 100 bbb csc 2010-01-28 2020-12-31
Thanks in adavance
.....