It's all about the answers!

Ask a question

data warehouse contains duplicate data from across multiple repositories, help?!


sam detweiler (12.5k6186201) | asked Nov 28 '12, 2:48 p.m.
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



permanent link
Hopeshared Lee (1121) | answered Nov 28 '12, 10:24 p.m.
JAZZ DEVELOPER
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?

permanent link
sam detweiler (12.5k6186201) | answered Nov 28 '12, 11:26 p.m.
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


Register or to post your answer.