Define the Target Model

Before working with a specific designer, you should define the Target model and the related associations and mappings. The Target model describes the final version of the data that adheres to the design required by applications. Each table in the model contains both designed columns and static columns, which comprises the metadata, so that the administrator can have the visibility of ETL processing over the entity’s data.

Target Model – Dimension or Fact: The target data models describe the format of the data that produces business intelligence analytics. The instantiated data models are dimension, fact, and hierarchy tables.

In the Architect Target Designer you define the target model containing the entities and links between them.