Scd type 2 without using component

[lmit]

Hi all,

How can I implement scd type 2 without using scd type 2 components?

For sample
Id,name,course,key
1,xxx,jjj,k1
2,yyy,KKK,k2

For first load data will be loaded as its is.for second load if data is like below
Id,name,course,key
1,ccc,jjj,
3,ddd,lll

My output should be

Id,name,course,key
1,xxx,jjj,n
2,yyy,KKK,k2
1,ccc,jjj,y

The key column for old record should change to n and new one should be y

Any help would be helpful.

Thanks in advance,
Lmit

[lmit]

Hi arpit,

Strange mine was also int datatype only.can you try below one
!(varid== null)

Thanks,
Lmit

[Anonymous]

Hi arpiita
About the compile error, check the 'nullable' box of userid column in the row1 schema.

Regards
Shong

[Anonymous]

Still getting error

Job:

Tmap

Error;

Thanks,
Arpit

[Anonymous]

Can someone have look at this and tell me where i am going wrong?

please its urgent.

[Anonymous]

Hello,

Did you put your filter in expression filter? Please use "||" instead of "&&" in your expression.

Best regards

Sabrina