Hello All
I have a scenario for SCD Type 2 and i need to know the best way to handle it.
Trying with Change Capture Stage.
Source Data (SQL Server)
1,ABC
1,CDE
LKUP DATA (SQL Server)
1,XYZ
Expected Output:
ID DESC STAT
1 XYZ N
1 ABC N
1 CDE Y
Regards
DS User
CDC Multiple Changes at the same run
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Due the C++ version mismatch with 8.1 SCD is not working
I cant at this moment. Due the C++ version mismatch with 8.1 SCD is not working. So i have no other choice. Shall i use the Server HASH LOOKUP to do this?ray.wurlod wrote:Why not use SCD stage?
Guide me.
Thanks
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sorry Rayray.wurlod wrote:Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"?
I didnt explained properly.
It is not just to convert "Y" to "N". I need to close the present record date - 1 as the close date to the previous record.
Let me check with lookup and let you know.
Thanks
DS User