[Answers] RRDI questions about the Data Warehouse
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.
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
Anthony,
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.