DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
browneyedfreak
Participant



Joined: 20 May 2020
Posts: 1

Points: 36

Post Posted: Wed May 20, 2020 12:42 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Windows
Hi All,

So i am trying to do the following with a CDC followed by a transformer, say when updating an old record i want to keep the old record but flag it to N and insert a new record but flag that as Y. So basically i want to be able to keep the old record but flag it N, and insert and update the old record with say the same id as the old record but different name but flag it Y. so the updated record has a new name and flagged Y but same ID.
I have tried using a copy option in CDC but that doesn't work. Would i maybe have to do a stage variable? or how would the conditions work in a transform if i were to do that?
Right now i have after the CDC a transform stage where i have 2 output links:
1. code 1 and 2 flag Y
2. code 3 flag Y, i am missing the part where i keep the old record but flag it N.

I am loading this into just one dataset.

please help. thank you.
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54570
Location: Sydney, Australia
Points: 295936

Post Posted: Tue May 26, 2020 11:24 pm Reply with quote    Back to top    

Welcome aboard.

Before I look at your logic may I ask whether you've investigated the Slowly Changing Dimension stage, which can do everything in your post?

Also, by CDC do you mean the Change Capture stage? Or perhaps, the Difference stage?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours