Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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..


0 votes



2 answers

Permanent link
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?

0 votes


Permanent link
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.

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Nov 28 '12, 2:48 p.m.

Question was seen: 5,373 times

Last updated: Nov 28 '12, 11:26 p.m.

Related questions
Confirmation Cancel Confirm