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
3. After the completion of the job, right-click the target and select Open to view the
generated surrogate key values. The following display depicts the target table data
for the sample job.
Display 24.9 Key Columns and Change Tracking Columns in the Sample Target Table
Comparing Tables
Problem
You want to detect changes between two tables such as an update table and a master
table. For example, a PRICE_COST update table could contain the unit cost and unit
price of all products currently being promoted through a channel. At the same time, a
PRICE_COST_HIST table could serve as the master table.
You need to accommodate the following inputs and outputs ...
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