SAS ETL Studio CaseStudy Tasks in SAS BI

• (4.0)

• | 1525 Ratings |

• Last Updated April 14, 2017

Course CaseStudy Tasks

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

Sas ETL Studio Casestudy Tasks
SAS ETL Studio will concentrate on the following four tasks:

These tasks will be performed in sequence:

SAS ETL Studio CaseStudy – Setup Tasks

SAS ETL Studio CaseStudy – Define Sources

SAS ETL Studio CaseStudy – Define Targets

SAS ETL Studio CaseStudy – Define Jobs

Creating the OrderFact Table

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

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

                                                 Checkout SAS BI Interview Questions

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

Creating the Product Dim Table

The ProductDim table will be created from the Product_List table.

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

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

SAS ETL Studio CaseStudy – Setup Tasks