SAS ETL Studio Wizards - SAS BI

There are shortcuts which invoke wizards that aid the user in performing various tasks with Sas ETL Studio.
Some of these wizards are:

Source Designer

Target Designer

New Job.

Source Designer

The Source Designer is a wizard-driven interface that enables you to define the physical layout of existing tables using a data dictionary or metadata information from the source system.
The result of running the Source Designer successfully is a metadata registration that describes the data source.

>>Unlike the SAS Warehouse Administrator product, which requires that, you must create Operational Data Definitions (ODDs) one table at a time, the Source Designer enables you to input the metadata from multiple tables with one pass through the wizard.
>>If the table is stored in an ERP System, the corresponding Data Surveyor will be invoked. The Data Surveyor contains information about the metadata of the source system.
>>If the table is a flat file, you can use a wizard to define the record layout. The Source Designer can be invoked by following these steps:

• Click on the Source Designer icon from the Shortcut
• Select Tools Ð Source Designer….
• Right-click on the Source Tables group and select New Object Ð Source Table.

Target Designer

The Target Designer is a wizard that allows metadata to be entered for a target.
In designing the target table, you can

• access any metadata about any source tables and columns registered in the metadata repository
• override any metadata that was imported from another source and add new columns to the target table
• create indexes on the target table being

The target designer can also specify

• the location of the target table
• table-specific options to be stored in the metadata

The Target Designer can be invoked by following these steps:

• Click on the Target Designer icon from the Shortcut bar.
• Select Tools Ð Target Designer….
• Right-click on the Target Tables group and select New Object Ð Target Table.

The person designing the target table has full control over the type of table being built.
The types of targets that can be built include

• database types that are supported by the SAS/ACCESS products
• SAS data sets (including both data files and data views)
• SAS/SHARE data sets
• SPDE tables.

SPDE – Scalable Performance Data Engine

New Job Wizard

The New Job wizard enables you to define the metadata necessary to run an ETL process to load data into a target or targets.

An empty job can be created, without importing metadata from any predefined target table, by clicking  without selecting the metadata for a table. Objects from the tree view can then be dragged and dropped into the empty job.
You can invoke the New Job wizard by following these steps:

• Click on the Process Designer icon from the Shortcut
• Select Tools Ð Process Designer….
• Right-click on the Jobs group and select New Object Ð Job.

Additional Wizards

Other wizards available to provide assistance with various tasks in SAS ETL Studio include

• Metadata Importer
• Metadata Exporter
• Cube Designer
• Transformation Generator wizard.

You can also install optional data surveyor wizards, which provide access to the metadata in enterprise applications, such as PeopleSoft, SAP R/3, Siebel, and Oracle.
These wizards can be invoked from the Shortcut Bar or the Tools pull-down menu of SAS ETL Studio:

                                                   Checkout SAS BI Interview Questions

Options Window

The Options window can be used to define standard settings for the SAS ETL Studio interface.
There are several tabs in the Options window:

• General
• Process
• Editor
• Metadata Tree
• SAS Server
• Data Quality.

Using the Options window tabs, you can control the following: