CDC Multiple Changes at the same run

SURA · Post by **SURA** » Tue May 10, 2011 10:46 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed May 11, 2011 3:28 am

Why not use SCD stage?

SURA · Post by **SURA** » Wed May 11, 2011 4:12 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed May 11, 2011 4:26 pm

Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"?

SURA · Post by **SURA** » Wed May 11, 2011 5:30 pm

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