Deleting existing rows of the table
Posted: Thu Nov 29, 2007 11:45 am
Hi All,
I have a need to delete the records of a certain table at the end of the sequence . I have created a job for this where i am using a transformer(input) and a oracle stage(output) where the transformer only has output rows which is nothing but the columns of the particular table i'm trying to delete. and i have set the value of all of it as 0 . and i have given the constraint as LinkRowCount =1 .In the Oracle stage i have given the update action to be "Delete existing rows only "
But i see that the records are not getting deleted
I also was wondering if i can give a after job subroutine in the last job of the sequence where it deletes the records of the table i'm trying to delete.
If so could someone let me know what is the query i'm suppose to write in the after job subroutine .
Any help would be highly appraciated .
Thanks
I have a need to delete the records of a certain table at the end of the sequence . I have created a job for this where i am using a transformer(input) and a oracle stage(output) where the transformer only has output rows which is nothing but the columns of the particular table i'm trying to delete. and i have set the value of all of it as 0 . and i have given the constraint as LinkRowCount =1 .In the Oracle stage i have given the update action to be "Delete existing rows only "
But i see that the records are not getting deleted
I also was wondering if i can give a after job subroutine in the last job of the sequence where it deletes the records of the table i'm trying to delete.
If so could someone let me know what is the query i'm suppose to write in the after job subroutine .
Any help would be highly appraciated .
Thanks