DWH & CCM DB Schemas
Our company uses RTC. I want to create SQL queries to read RTC data from DB directly. I've already created a lot of queries. And all of them select data from DHW schema. ... But now I have a problem.
Business Need work item has customized field “Target Release” in our RTC system. The field allows to select one of iterations. I’ve found values of this field in “model”.”work_item_item_extensions” table of CCM schema and I’ve not found this field in DWH schema which I use for queries.
The questions: is data from “model”.”work_item_item_extensions” table copied from CCM to DWH schema or not? if yes in which table?
One answer
I think the following document may help you:
http://www.ibm.com/developerworks/rational/library/add-a-rational-team-concert-data-warehouse-extension-for-custom-attributes/index.html
Regards,
John
Comments
Thank you John! I will look in the document.
I've looked in the document. It was very interesting. Now I know how custom attributes are stored better. But my question still exists ...
Values of “Target Release” custom attribute are stored CCM schema (“model”.”work_item_item_extensions” table). I found them. It's clear for me.
Data from ССM schema are transferred to DWH schema according to a schedule.
Table structure of DWH schema differs from table structure of CCM schema. And my problem is I cannot find “Target Release” custom attribute in tables of DWH schema.