The Target Designer is a wizard that can create new metadata about a single table that might or might not already exist in physical storage.
It can also be used to create and edit metadata about an OLAP cube.
The Target Designer is an easy to use wizard interface.
Selecting Cube Designer in the first window of the Target Designer will launch the Cube Designer wizard.
The next step in the implementation of the orion star marketing data mart is to use the Target Table Designer to define the target tables for the ETL process.
Select Target Designer from the Shortcut bar of the sas etl studio desktop.
Select Target Table as the type of target to design.
Select
ORDER_ITEM table | Order_ID Product_ID Quantity Total_Retail_Price CostPrice_Per_Unit |
ORDERS table | Order_Type Order_Date Delivery_Date |
Select
To add an additional column definition, select
Checkout SAS BI Interview Questions
Additional metadata items can also be specified for each column:
Summary Role | defines the role of the column in summary data |
Sort Order | defines how the values in the column are sorted |
Informat | defines the SAS informat to be used in reading the data. |
Format | defines the SAS format to be used in writing the data. |
Is Nullable | indicates whether or not the column can contain null or missing values. |
.Select
.The type of file selected in the DBMS field controls the type of storage intended to be utilized for the new target table. The selection arrow shows a list of DBMSs that are valid in the current context (that is, SAS, Oracle, SAP, Sybase, and so on).
To add a new library definition, select
The metadata definition for the target table OrderFact is now defined.
8. Move the table OrderFact to the Target Tables group.
It is possible to update a defined table in the metadata repository with additional information. The following demonstrates adding additional columns – this could have been done during the initial specifications but can also be done at a later point.
9. From the Custom tab in the tree view area of SAS ETL Studio, expand the Target Tables group.
10. Right-click on the OrderFact table and select Properties from the pop-up menu.
11. In the OrderFact Properties window, select the Columns tab.
12. Select the Delivery_Date row so that the new columns will be added to the end of the list.
New columns are added after the row of information that is currently selected.
13. Select
Name | Description | Type |
Order_Qtr | Quarter Order was Placed | numeric |
Order_Month | Month Order was Placed | numeric |
Delivery_Time | Number of Days Until Delivery | numeric |
15. Select
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
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.
1 / 15
Copyright © 2013 - 2023 MindMajix Technologies