win_bhatia

 Profile Answers by win_bhatia Questions by win_bhatia

• Jan 2nd, 2010

 

Using performance recovery option in Session property.

Recover session from the last commit level.

Regards
Puneet

srinivas jupally

 Profile Answers by srinivas jupally Questions by srinivas jupally

• Feb 18th, 2010

 

OPB Server you can find how many records are loaded in your target and set session properties.

Infatech

 Profile Answers by Infatech 

• Apr 14th, 2010

 

Different companies use different strategies to recover the workflows.

1) You can use the session properties to Recover from last check point.
2) Use a temporary table before every target and load it with the keys. When a job fails,
You can identify the rows that are not loaded from the source by using these keys in SQL override
3) You can delete the rows that are loaded in to the target by date, and restart the job from begining.

reddykuruganti

 Profile Answers by reddykuruganti 

• Jun 7th, 2010

 

Simply you can restart the session, by selecting truncate table option in the session properties.

jayapraveen

 Profile Answers by jayapraveen 

• Oct 3rd, 2010

 

With Incremental Aggregation.