Mindmajix

SAS ETL Studio CaseStudy Tasks

Course CaseStudy Tasks

Recall the case study tasks diagram discussed earlier. Each of these tasks involves either reading or writing (or both) metadata.

Screenshot_1253

SAS ETL Studio CaseStudy Tasks

SAS ETL Studio will concentrate on the following four tasks:

Screenshot_1254

These tasks will be performed in sequence:

Screenshot_1255

SAS ETL Studio CaseStudy – Setup Tasks

Screenshot_1256

SAS ETL Studio CaseStudy – Define Sources

Screenshot_1257

SAS ETL Studio CaseStudy – Define Targets

Screenshot_1258

SAS ETL Studio CaseStudy – Define Jobs

Screenshot_1259

Creating the OrderFact Table

The OrderFact table will be created from the Orders and Order_Item tables.

Screenshot_1260

The source tables, Orders and Order_Item, will be combined using the SQL Join transformation.

Screenshot_1261

The table that is the result of the SQL Join will then be loaded into the OrderFact table.

Screenshot_1262

Creating the Product Dim Table

The ProductDim table will be created from the Product_List table.

Screenshot_1263

The Extract transformation will be used so that a computed column can be defined.

Screenshot_1264

The results of the Extract transformation will then be loaded into the target table, ProductDim.

Screenshot_1265

SAS ETL Studio CaseStudy – Setup Tasks

Screenshot_1266

 

 

 

 


 

0 Responses on SAS ETL Studio CaseStudy Tasks"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.