Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
SAS Data Integration Studio 3.3- P43:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | Using Slowly Changing Dimensions A Create and Populate the Job 205 In this example three additional columns will be specified for CUSTOMER_SCD two change-tracking columns VALID_FROM_DTTM and VALID_TO_DTTM and a column for generated keys CUSTOMER_GEN_KEY . CUSTOMER_TRANS and CUSTOMER_SCD have been registered in a current metadata repository. You have selected a default SAS application server for SAS Data Integration Studio as described in Selecting a Default SAS Application Server on page 96. This server can access all tables that are used in the job. The main metadata repository is under change-management control. For details about change management see Working with Change Management on page 113. It is assumed that you have started SAS Data Integration Studio and have opened the appropriate metadata profile. The first task is to check out any existing metadata that must be updated for the current job. Check Out Existing Metadata That Must Be Updated You do not have to check out the metadata for a table in order to add it as a source or a target in a job. However the metadata for the CUSTOMER_SCD table must be checked out because a we assume that the metadata for this table was created and checked in earlier and b the metadata for the table must be updated for the current job. Follow these steps to check out existing metadata 1 On the SAS Data Integration Studio desktop select the Inventory tab. 2 In the Inventory tree open the Tables folder. 3 Select the table that must be updated for the current job CUSTOMER_SCD. 4 Select Project Check Out from the menu bar. The metadata for this table will be checked out and will appear in the Project tree. The next task is to create and populate the job. Create and Populate the Job Follow these steps to populate the job Load the Customer Dimension 1 In SAS Data Integration Studio in the Shortcuts pane click Process Designer to start the New Job Wizard. 2 In the New Job Wizard type the job name Load the Organization Dimension and
