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 Table and Adding a Surrogate Primary
Key
Problem
You want to create a job that loads source data into a target and adds a primary key
column. The added key column is known as a surrogate key. The surrogate key in the
target replaces the primary key that is loaded into the target from the source. The
surrogate key is required because the target contains multiple instances of the primary
key in the source.
Solution
You can create a job that includes the Surrogate Key Generator transformation. This
transformation is more efficient than the SCD Type 2 Loader because you are not
tracking data changes in the target.
The sample job includes the ...
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