Page 1 of 1
CDC Multiple Changes at the same run
Posted: Tue May 10, 2011 10:46 pm
by SURA
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
Posted: Wed May 11, 2011 3:28 am
by ray.wurlod
Why not use SCD stage?
Due the C++ version mismatch with 8.1 SCD is not working
Posted: Wed May 11, 2011 4:12 pm
by SURA
ray.wurlod wrote:Why not use SCD stage?
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?
Guide me.
Thanks
DS User
Posted: Wed May 11, 2011 4:26 pm
by ray.wurlod
Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"?
Posted: Wed May 11, 2011 5:30 pm
by SURA
ray.wurlod wrote:Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"?
Sorry Ray
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