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
Logic
Moderators: chulett, rschirm, roy
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: