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:
The Target Designer is a wizard that allows metadata to be entered for a target.
In designing the target table, you can
The target designer can also specify
The Target Designer can be invoked by following these steps:
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
SPDE – Scalable Performance Data Engine
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:
Other wizards available to provide assistance with various tasks in SAS ETL Studio include
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:
Metadata Importer | enables you to import metadata from other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats. |
Metadata Exporter | enables you to export metadata to other applications that support the Common Warehouse Metamodel (CWM) format. Optional bridges are available for other formats. |
Cube Designer | is a target designer that enables you to create a cube, a data store that supports Online Analytical Processing. |
Transformation Generator |
enables you to create a user-written, SAS code transformation and make it available in the Process Library tree. |
Checkout SAS BI Interview Questions
The Options window can be used to define standard settings for the SAS ETL Studio interface.
There are several tabs in the Options window:
Using the Options window tabs, you can control the following:
General | controls the overall display of SAS ETL Studio and the functionality of the wizards. |
Process | controls the look and feel of the process editor window. |
Editor | controls the look and feel of the SAS text editor for generated code. |
Metadata Tree | controls the tree view in the middle portion of SAS ETL Studio. |
SAS Server | specifies the SAS server to be used with SAS ETL Studio, and tests the connection to the server. |
Data Quality | specifies options to control the locale, the types of files to be used by the data quality plug-ins, and the location of the Quality Knowledge Base (QKB). |
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.