Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
SAS Data Integration Studio 3.3- P27: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. | Registering Data Sources A Save the Metadata for the Tables 125 Save the Metadata for the Tables After you specify a group for storing the source tables use the Wizard Finish window to review the metadata that you entered. Display 8.5 Wizard Finish Window Review the text in the metadata pane on the Wizard Finish window. Shown previously is the metadata for the CUSTOMER ORDERS and ORDER_ITEM source tables. If the metadata is correct click Finish. The metadata for the tables is written to the current metadata repository. At this point you could add the metadata that you just created to a job or you could check in the metadata. 126 Check In the Metadata A Chapters Check In the Metadata Under change management new metadata objects are added to the Project tree on the SAS Data Integration Studio desktop as shown in the following display. Display 8.6 Project Tree with Metadata Objects for Three Tables You must check in the new table metadata in order to save it to the change-managed repository. 1 In the Project tree select the repository icon Project etlDev4 . 2 From the SAS Data Integration Studio menu bar select Project Check In Repository. All metadata objects in the project repository will be checked into the change-managed repository. The new objects will be visible in the Inventory tree. Example Using a Source Designer to Register an External File Preparation An external file is a file that is created and maintained by a host operating system or by another vendor s software application. SAS can read data from and route output to external files. Suppose that you wanted to create a report that requires information from a comma-delimited external file. Your first task would be to register this file so that it an be included in a job that creates the report. Because the file is in comma-delimited format you would use the Delimited External File source designer wizard to register the file. Assume that the following preparations have been made The comma-delimited .
