It's all about the answers!

Ask a question

How do I pull only specific ClearQuest info through Data Services into the Data Warehouse

Michael Walker (99214198157) | asked Mar 11 '14, 3:33 a.m.
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

One answer

permanent link
Jackie Albert (1.6k14846) | answered Mar 11 '14, 9:12 a.m.

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. 

Your answer

Register or to post your answer.