Page 1 of 1
Loading and Deleting in a Single Unit of Work
Posted: Tue Jun 19, 2007 8:40 am
by 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 ?
Posted: Tue Jun 19, 2007 9:00 am
by 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.
Posted: Wed Jun 20, 2007 6:17 am
by 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
Re: Loading and Deleting in a Single Unit of Work
Posted: Wed Jun 20, 2007 6:49 am
by Govindarajan
ag_ram wrote: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.
Posted: Wed Jun 20, 2007 7:02 am
by ray.wurlod
What's in a name? Close in some stages, After in others.
Re: Loading and Deleting in a Single Unit of Work
Posted: Sat Jun 23, 2007 4:30 am
by ag_ram
Govindarajan wrote:ag_ram wrote: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 !
Posted: Sat Jun 23, 2007 7:17 am
by ray.wurlod
There's no tab, but there IS an available property to add.
Posted: Sat Jun 23, 2007 11:08 am
by 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 !