How do I pull only specific ClearQuest info through Data Services into the Data Warehouse
We installed Rational Insight Data Services and connected it to the customer's CQ repository. I want to only pull data into the Data Warehouse that meets a specific criteria for the Project field like 'where Project = 'Project A'. Where would I do this? I could only find documentation on adding new fields or attributes to the xdc file.
Not sure if in this case I do it through the Data Manager ODS jobs and add on to the where clause where 'modified_since' is or in the xdc file. Is there any documentation on this? Customer is on Insight 1.1.1.2 |
One answer
Hi Michael, You'd want to do this in the Data Manager job, and add an additional filter on the where clause after the 'modified_since', rather than in the XDC file itself. |