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)
.png)
.png)
.png)
.png)
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)
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)
.png)
2357 Enrolled
3370 Enrolled
1324 Enrolled
1563 Enrolled
2925 Enrolled
4025 Enrolled
1045 Enrolled
1578 Enrolled
1956 Enrolled
1483 Enrolled
1090 Enrolled
3063 Enrolled
921 Enrolled
1899 Enrolled
3353 Enrolled
3766 Enrolled
1458 Enrolled
3819 Enrolled
1385 Enrolled
75 Enrolled
Get Updates on Tech posts, Interview & Certification questions and training schedules