clean database
Posted: Mon Jan 02, 2006 3:54 am
I need to clean database for repeated testing the data,
I used two oci stage and a transformer and in the target oci i gave the update action as "clear the table and insert",when I tried to run the job,it shows in the director that it is running,but in the Datastage job the if we check the performance statistics it shows 0 rows populating nad the job still continue to run without deleting the records,
Best suggestions please.I know it is very silly ,but I need your utmost suggestions
Thanks in advance
I used two oci stage and a transformer and in the target oci i gave the update action as "clear the table and insert",when I tried to run the job,it shows in the director that it is running,but in the Datastage job the if we check the performance statistics it shows 0 rows populating nad the job still continue to run without deleting the records,
Best suggestions please.I know it is very silly ,but I need your utmost suggestions
Thanks in advance