SAS Data Integration Studio 4.9

Loading a Fact Table Using Dimension Table

Lookup

Problem

You want to load numeric source data into a fact table and add foreign keys from a

dimension table.

Solution

You can create a job that uses the Lookup transformation, which loads fact data from a

source table and uses a lookup process to load foreign keys from the dimension table.

The lookup process compares the business key in each source row to the business keys

in the dimension table. When the business keys match, the foreign key from the

dimension table is loaded into the fact table target.

This sample job assumes that you have already loaded data into your dimension table

before you run ...