How to run Delta Load since a specified date in Insight

0	Adam Wereszczynski (928●1●17●32) \| asked Nov 12 '15, 3:09 a.m. In IBM Rational Insight integrated with IBM Rational Collaborative Lifecycle Management (CLM) solution, I want to run a Delta Load since a specified date. How can I run Delta Load since a specified date in Insight?

One answer

Most liked answers|Newest answers ↓|Oldest answers

permanent link

Adam Wereszczynski (928●1●17●32) | answered Nov 12 '15, 3:33 a.m.
edited Nov 12 '15, 4:00 a.m.

To run a Delta Load since a specific date, you need to modify the Prepare script inside the respective JobStream.

You can see the example for IBM Rational Team Concert 5.0 Work Item Delta Load below.

To run a Delta Load since a specified date:

Open IBM Cognos Data Manager.
Navigate to the RTC_Workitem5.0 job.
Double-click on the Prepare procedure.
Navigate to the Action tab.
Comment line 3 by placing two forward slashes in front of it. It should look like presented below:
```
//$MODIFIED_SINCE := GetNFLastETLSuccessDateTime( $RESOURCEGROUP_ID ,$DeltaLoad );
```
Create a new line with the following content below the now commented line 3:
```
$MODIFIED_SINCE := 'yyyy-mm-dd hh:mi:ss';
```
Where 'yyyy-mm-dd hh:mm:ss' is the desired date from which the Delta Load will be run.
Save the changes.
Execute the RTC_ODS5.0_Workitem_DeltaLoad job.

It's all about the answers!

Related questions

How to run Delta Load since a specified date in Insight

One answer

Your answer