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:
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.
The table that is the result of the SQL Join will then be loaded into the OrderFact 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.