hi to all
Can anyone explain me how can I do rollback in DRS stage.
My problem is like this.Suppose my source contains 100 records and my job get abort after 50 records.But I don't want these passed 50 records to be seen in my target table and my target is DRS is that possible.
Thanks in advance
Mohan
Rollback in DRS stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
Or Split your job into 2 jobs:
the first does all the validations and writes the output to a sequential file
the second reads the file and loads the database.
The first job can then abort without any evil consequences.
the first does all the validations and writes the output to a sequential file
the second reads the file and loads the database.
The first job can then abort without any evil consequences.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
Or just set the transaction size to zero.
That turns your load into an 'all or nothing' load and the records are only commited once at the end if the job completes without fatal errors. In other words, the job must abort for the rollback to occur. This means running the job with a very low Warning threshold or enabling the 'Treat warnings as fatal' option in the stage if available.
No evil consequences here either, if done properly.
![Wink :wink:](./images/smilies/icon_wink.gif)
That turns your load into an 'all or nothing' load and the records are only commited once at the end if the job completes without fatal errors. In other words, the job must abort for the rollback to occur. This means running the job with a very low Warning threshold or enabling the 'Treat warnings as fatal' option in the stage if available.
No evil consequences here either, if done properly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
absolutely .. i agree.. but i recall reading a comment here about it being good job design to disconnect" the transform and the load parts of a "job" (But considering my non-existent short term memory, i might be wrong
).
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>