Capturing Before Image for Audit

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Su
Participant
Posts: 13
Joined: Thu Sep 26, 2002 7:16 am

Capturing Before Image for Audit

Post by Su »

Hi,

I need to create a parallel job that does an update or insert and in the case of update, I need to insert the old record into an audit table.

My job is as follows (sorry - am not able to attach an image here)

BeforeData(Oracle Stage O1) -> ChangeCapture (C1)
AfterData (Oracle Stage O2) -> ChangeCapture (C1)

C1 outputs only insert(change_code = 1) and update (Change_code = 3 - edit) to a Transformer Stage(T1)

T1 -> Oracle Stage (O3) (insert/update)

How do I get BeforeData to insert into an audit table?

I thought of having a lookup stage into T1 but am not able to have a reference link into T1.

Also am not able to get the before image when using a change apply stage.


Any help is appreciated.

Thanks
Post Reply