I'm new to Datastage.I need your suggestions for implementing the logic.
Here is the situation
X is the source
Y is the target
Z is a target in a warehouse
Today the job was run X->Y-->Z
Tommorow, certain rows from X are deleted
I need to update those records in Z which are deleted in X to 'DELETE' in the Z table(Flag the particular record which was deleted from the source)(As I have to maintain the history of the source table in Z)
any suggestions wud be greatly appreciated.
Thanks....
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
![Idea :idea:](./images/smilies/icon_idea.gif)
![Question :?:](./images/smilies/icon_question.gif)
![Idea :idea:](./images/smilies/icon_idea.gif)