Blog

  • Home
  • SAS BI
  • SAS ETL Studio CaseStudy Tasks in SAS BI

SAS ETL Studio CaseStudy Tasks in SAS BI

  • (4.0)
  • | 1831 Ratings

Course CaseStudy Tasks

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

Learn more about our SAP BI Training Videos to get ahead in your career.

Metadata

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

Sas ETL Studio

These tasks will be performed in sequence:

Tasks

SAS ETL Studio CaseStudy – Setup Tasks

SAS ETL Studio

SAS ETL Studio CaseStudy – Define Sources

SAS ETL Studio CaseStudy – Define Sources

SAS ETL Studio CaseStudy – Define Targets

SAS ETL Studio CaseStudy – Define Targets

SAS ETL Studio CaseStudy – Define Jobs

SAS ETL Studio CaseStudy – Define Jobs

Creating the OrderFact Table

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

Creating the OrderFact Table

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

SQL Join

                                                 Checkout SAS BI Interview Questions

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

OrderFact table

Creating the Product Dim Table

The ProductDim table will be created from the Product_List table.

Product Dim Table

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

SAS Extract

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

Loader

SAS ETL Studio CaseStudy – Setup Tasks

SAS ETL Studio CaseStudy – Setup Tasks



Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Vinod M
About The Author

Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close