DSXchange

Hi
I have input data with n fields

I have requirement that if there is change in input
Data then recordupdate date = current date else recordupdatedate

What is best approach. I thought of using funnel stage and compare string in transformer. Let me know any other better approach

Thks

I honestly have no idea what your requirements are here. Rather than guess, would it be possible to post some examples of the input data and then examples of what the output data should look like after the application of your... logic?

Hi

Sorry for not clear in requirements

1) if before Data set data is equal to After dataset then Record_update_date=currenttimestamp ----day 1
2) if before Data set data is equal to After dataset then Record_update_date=same timestamp as day 1 ----day 2
3) if before Data set data is not equal to After dataset means some change in data then Record_update_date=currenttimestamp ---day 3
3) if before Data set data is equal to After dataset means no change in data then Record_update_date=sametimestamp (day 3) --
and soo on

what is the best stage .

if I use CDC stage then all the after records are populated to changed dataset.if the change code -3 or 1 then how can I apply logic for record_update_date.

please let me know

Try using a Change Capture stage. Test the change_code downstream in a Transformer stage and derive the output accordingly.