Mindmajix

SAS ETL Studio CaseStudy – Adding A Source Table Definition

Using the Source Designer

The Source Designer is a wizard that generates metadata for one or more selected tables, based on the physical structure of the table(s).

The Source Designer can be used to specify metadata for any existing table, not just tables used as data sources for ETL jobs.

The Source Designer supports a number of specific data formats that have been licensed for a site. The specific format will often give better results than the generic format, which has not been optimized for particular kinds of data. Use the format that most closely matches your data whenever possible.

The Source Designer is an easy to use wizard interface.

Screenshot_1286

SAS ETL Studio CaseStudy – Define Sources

Screenshot_1287

Add a Source Table Definition

The next step in the implementation of the Orion Star marketing data mart is to define the source table to be used in the ETL process.

Screenshot_1288

  1. Select Source Designer from the Shortcut bar of the SAS ETL Studio
  2. Select SAS as the metadata import source

Screenshot_1289

Select Screenshot_1212

     3. Select Source Tables Library as the SAS Library.

Screenshot_1290

Select Screenshot_1212to access the Define Tables window.

      4. Select the source table ORDERS from the Select Tables list.

Screenshot_1291

Select Screenshot_1212 to access the Select Group window.

     5. Select the Source Tables group

Screenshot_1292

Select Screenshot_1212 to access the Wizard Finish window.

     6. Verify that the information is correct, then select Screenshot_1223

Screenshot_1293

 

 

 

 

 

 


 

0 Responses on SAS ETL Studio CaseStudy – Adding A Source Table Definition"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.