DSXchange

Hi, I need to implement SCD-2 in datastage server jobs Like parallel (change capture stage) do we have any stage in server for SCD? My job design like : seq file(after data)) -> transformer ->insert and update | Hash file(before data) what logic need to be used in transformer stage.. help me to proc...

we need to apply some logic in transformer stage using stage variable... i am not sure with the logic used..... source file target 1 target 2 102 100 102 106 102 106 108 106 102 108 106 100 can any one tell me some logic for this....

My requirement is need to use only transformer stage..... for Capturing duplicate records........

can u help me with some logic

Thanks in advance

Hi,

I need to capture the duplicate record to the seperate table......only by using transformer stage

Thanks in advance

Hi,

I have source like.... Its an year in the format (yy)

86,78,98,04,01,05....

i need to convert this source into (yyyy) format... target as..

1986,1976,1998,2004,2001,2005....

Thanks in advance