SAS DI STUDIO (Data Integration Studio)

SAS DI STUDIO (Data Integration Studio)

Courses Info

SAS DI STUDIO (Data Integration Studio)

Exploring SAS Data Integration Studio
Working on Change Management
Explaining how to define source, target data structures and designing jobs.
Introduction to jobs and the job editor
Working with propagation and mappings
working with intermediate files
working with the extract transformation
working with summary statistics transformation
explore status handling for transformations and jobs
working with the data validation transformation
working with the sort transformation
working with the append transformation
working with the transpose transformation
working with the apply lookup standardization transformation
iterating a job with Loop transformations
basics of the Table Loader transformation
load styles of the Table Loader transformation
table properties and load techniques of the Table Loader transformation
Defining slowly changing dimensions
Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
analyzing metadata using impact analysis