data warehouse contains duplicate data from across multiple repositories, help?!
![]()
we run multiple repositories (ccms), and collect all the data into a common warehouse, using Rational Insight (and its etl data movement jobs).
now all the workitems are in one big common database.. (we know we have duplicate workitem IDs) for business reporting purposes we need to report on the iteration a workitem is in, but when we look for a specific iteration name from its ID, we are getting multiple results. it appears the calculation of the iteration uuid is good for one server, but may cause duplicates across servers. help.. |
2 answers
![]()
Which job do you use to load data? Java ETL, DM ETL that imported from RTC, or Insight out-of-the-box RTC 2.x DM ETL?
|
![]()
We just started using the Insight ETL. but its the same as the DM ETL before that.
we are on rtc 3.0.1.1. we know some fixes we requested are in the Insight 1.1.1.1 we have a PMR open on this topic as well. |
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.