DW Environment

Question 1

Maintaining the DW data

Answer 1

Initial load: done once to get the data into the DW
Historical load: done once to get archived data in the DW
Incremental load: ongoing to keep data in DW up-to-date with operational changes. Frequency depends

Question 2

The DW debate

Answer 2

Top down - Bill Inmon - data model for DW then have your data marts

Bottom up - Ralph Kimball - create separate data marts and combine them to make DW

Question 3

The right time data

Answer 3

Bulk of data in DW is just in case data

Just in time data is right time data. (Used in transactions done on subsets of the DW)

Question 4

Operational Data Store (ODS)

Answer 4

• right-time transactions done on source data that has been semi-integrated
• in time the data is integrated and moved to the DW

Question 5

Exploration DW

Answer 5

Separate from enterprise DW

Processing can be done without affecting the enterprise DW performance

Freezes data so results of different iterations are compared

Question 6

Is it beneficial to base a performance dashboard on a BI and data integration infrastructure and why

Answer 6

Yes, because it enables the organisation to monitor, measure and manage business performance more effectively.
Makes sure business is using the most up-to-date data. And helps identify the most useful KPIs and betters the decision support process