Loading and Deleting in a Single Unit of Work

[ag_ram]

Hi Folks

Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ?

[DSguru2B]

Sure. You can pass the delete command in the OPEN/CLOSE option of the enterprise stage and do your regular operation of load or upsert.

[ag_ram]

Hi

When Oracle Enterprise is used as a Target Stage we dont have that option of open/close command..Correct me if iam wrong

[Govindarajan]

Hi Folks

Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ?

You can create userdefined SQL and place inside the After tab page. This will work.

[ray.wurlod]

What's in a name? Close in some stages, After in others.

[ag_ram]

Hi Folks

Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ?

You can create userdefined SQL and place inside the After tab page. This will work.

There is no before and After Tab in a prallel Oracle Enterprise stage !

[ray.wurlod]

There's no tab, but there IS an available property to add.

[ag_ram]

Hi

The OPEN/CLOSE is indeed available , and we used the same in solving the problem. It is available with Load/Append mode in Oracle Enterprise , but is not available for use with UPSERT mode.

Sorry for the confusion !