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
.....
scd stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: