Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

Creating a source matrix

Identifying the source of record for information within the conceptual model enables the project team to understand where the key information is sourced.

Getting ready

Gather the blueprint information and information obtained during the first recipe of this chapter.

How to do it...

The source matrix identifies the business source of record for each of the business entities:

1. Open your data lineage spreadsheet and create an additional tab called Source Matrix:
   
2. Place your business entities across the top of the worksheet:
   
3. From the ...