Course CaseStudy Tasks
Recall the case study tasks diagram discussed earlier. Each of these tasks involves either reading or writing (or both) metadata.
.png)
Sas ETL Studio Casestudy Tasks
SAS ETL Studio will concentrate on the following four tasks:
.png)
These tasks will be performed in sequence:
.png)
SAS ETL Studio CaseStudy – Setup Tasks
.png)
SAS ETL Studio CaseStudy – Define Sources
.png)
SAS ETL Studio CaseStudy – Define Targets
Subscribe to our youtube channel to get new updates..!
.png)
SAS ETL Studio CaseStudy – Define Jobs
.png)
Creating the OrderFact Table
The OrderFact table will be created from the Orders and Order_Item tables.
.png)
The source tables, Orders and Order_Item, will be combined using the SQL Join transformation.
.png)
Checkout SAS BI Interview Questions
The table that is the result of the SQL Join will then be loaded into the OrderFact table.
.png)
Creating the Product Dim Table
The ProductDim table will be created from the Product_List table.
.png)
The Extract transformation will be used so that a computed column can be defined.
.png)
The results of the Extract transformation will then be loaded into the target table, ProductDim.
.png)
SAS ETL Studio CaseStudy – Setup Tasks
.png)
