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
Key Effective Date
updates dimension tables based on changes to the business key, when change
detection is unnecessary.
Surrogate Key Generator
generates unique key numbers for dimension tables in a manner that is similar but
less feature-rich than the SCD Type 2 Loader transformation. Use the Surrogate Key
Generator when key generation is the sole task that is required at that point in the
job.
SCD Project Stages
The process for loading a star schema for slowly changing dimensions follows these
general steps:
1. Stage operational data. In this initial step you capture data and validate the quality of
that data. Your staging jobs make use of the Data ...
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