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
About the Loading of Fact Tables with the Lookup Transformation
To load data into a fact table, use the Lookup transformation in a SAS Data Integration
Studio job. The Lookup transformation generates primary key values, loads numeric fact
data from a source table, and loads foreign keys from dimension tables using a lookup
process.
The lookup process runs separately for each dimension table that contributes foreign
keys. The process compares business key values between the source table and a
dimension table. If a match is found, an expression (a WHERE clause) is evaluated to
identify the specific dimension table row in that business key. In general, ...
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