It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,883
×6,033
×1,230

question asked: Nov 28 '12, 2:48 p.m.
question was seen: 5,348 times
last updated: Nov 28 '12, 11:26 p.m.

Related questions

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

0
sam detweiler (12.5k●6●195●201) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Hopeshared Lee (11●2●1) | 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?
0
permanent link
sam detweiler (12.5k●6●195●201) | 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.


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.