Skip to Main Content
SAS Data Integration Studio 4.9
book

SAS Data Integration Studio 4.9

by SAS Documentation
August 2014
Intermediate to advanced content levelIntermediate to advanced
808 pages
25h 30m
English
SAS Institute
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

Ron Cody

Publisher Resources

ISBN: 9781629593098