Developing the data lineage

Data lineages are diagrams or information which trace information through the system. This gives you the big picture of the information flow within the business intelligence and data warehouse project.

Getting ready

Gather the blueprint information and information obtained during the development of different matrices' recipes for this chapter.

How to do it...

Creating a data lineage creates a visual flow of the information as it is understood by the project team. This provides the basis for the development of mappings to extract and load the data warehouse as follows:

  1. Open your data lineage spreadsheet and create an additional tab called Data Lineage, as shown in the following screenshot:
  2. On the left-hand side, enter your ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.