It's all about the answers!

Ask a question

[Answers] RRDI questions about the Data Warehouse

Anthony Kesterton (7.5k7178136) | asked Feb 21 '13, 4:39 a.m.
I had to find out some info about how RRDI works, and thought these might be useful to people here too:

Q:What order do the RRDI (and Insight) data load jobs run?
A: JTS jobs first, then RTC, then RRC. then RQM.  The first job in the JTS is always the Common job.

Q: Who runs the Data Warehouse job if you have RRDI installed?
A: The JTS and the different products run the jobs that load the Data Warehouse.  RRDI just uses the data held in the Data Warehouse rather than loading its own Data Warehouse.

Q: When you look at the logs for the Data Warehouse runs - what does the line Record Inserted and Record Updated mean? 
A: Record Inserted means a new record has been added to the Data Warehouse.  Updated means that the record has been updated (as you might expect).  However, it appears that an Update also means it has been scanned and it gets noted as an updated record even if it has not been changed, but merely confirmed it has been checked and is up-to-date.

Accepted answer

permanent link
James Moody (3.3k24) | answered Feb 27 '13, 10:54 a.m.
A couple of clarifications:

1. Just to be clear, RRDI doesn't have or run any ETLs - there are two kinds of ETLs. The Java-based ETLs which are included out of the box with CLM (regardless of whether you have RRDI), or the Cognos Data Manager ETLs which are included in the products but only used if you're using Insight.

2. Regardless, the ordering is a bit more complex than that. It's a bit more like this:
- Common job in JTS
- Common job in RTC/RQM, in no specific order
- RTC & RQM jobs
- RRC job (in the JTS)
- Star ETL (in the JTS)

Hope this helps.
Anthony Kesterton selected this answer as the correct answer

Anthony Kesterton commented Feb 27 '13, 12:04 p.m.

Thanks for the clarification James.

Your answer

Register or to post your answer.