It's all about the answers!

Ask a question

How to run Delta Load since a specified date in Insight

Adam Wereszczynski (92811932) | 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

permanent link
Adam Wereszczynski (92811932) | 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:
  1. Open IBM Cognos Data Manager.

  2. Navigate to the RTC_Workitem5.0 job.

  3. Double-click on the Prepare procedure.

  4. Navigate to the Action tab.

  5. Comment line 3 by placing two forward slashes in front of it. It should look like presented below:
    //$MODIFIED_SINCE := GetNFLastETLSuccessDateTime( $RESOURCEGROUP_ID ,$DeltaLoad );
  6. 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.

  7. Save the changes.

  8. Execute the RTC_ODS5.0_Workitem_DeltaLoad job.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.