How to run Delta Load since a specified date in Insight
One answer
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:
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.