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.
Different ways to recover scd type 2 data load failure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am
That would have required you to build an ETL framework that captures inserts and updates and the before images of the rows updated. You would delete your inserts and update your updates with the before-image. Otherwise, you're in to using database table recovery procedures such as logging to rollback a table post-load.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 150
- Joined: Tue Mar 13, 2007 1:17 am