Different ways to recover scd type 2 data load failure
Posted: Wed Apr 01, 2009 11:06 am
Hi ,
We have implemented scd type 2 functionality using datastage px jobs. However, We would like to automate the recovery of the data when job fails in between the load. Could you please suggest me the different possible methods? and we should be ok even if we have to go beyond ds like using a shell script or routine to do so.
We have implemented scd type 2 functionality using datastage px jobs. However, We would like to automate the recovery of the data when job fails in between the load. Could you please suggest me the different possible methods? and we should be ok even if we have to go beyond ds like using a shell script or routine to do so.