TAILIEUCHUNG - SAS Data Integration Studio 3.3- P12

SAS Data Integration Studio P12: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. | 50 Identifying Targets A Chapter 5 Sources Related to Geography The following tables can contribute to the geographic dimension of the OLAP data store CONTINENT table COUNTRY table STATE table COUNTY table CITY table STREET_CODE table Sources Related to Organization The following tables can contribute to the organization dimension of the OLAP data store STAFF table ORGANIZATION table Sources Related to Time The following tables can contribute to the time dimension of the OLAP data store CONTINENT table COUNTRY table STATE table COUNTY table CITY table STREET_CODE table While the previous tables contain the appropriate information it is not in the correct format for OLAP. To support OLAP several new data stores most be created as described in the following section. Identifying Targets In order to support the OLAP reports such as the one shown in Display on page 49 the data warehousing team specified the following new data stores A SAS cube that will support OLAP reporting. A set of new tables that will form the central fact table and dimension tables for a star schema. Each new table will be created by joining two or more source tables that are related to a particular dimension such as customers geography organization and time. The target tables are described in the following sections. Target to Support OLAP A SAS cube named Star will be created to support OLAP. This cube will support reports similar to Display on page 49. Example Data Warehouse A The Next Step 51 Target to Provide Input for the Cube In this example the ORDER_FACT table that is described in Target That Combines Order Information on page 48 is the central fact table in a star schema. Its dimension tables are described in the following sections. Target That Combines Customer Information The CUSTOMER_DIM table will be created by joining the tables described in Sources Related to Customers on page 49. In this example CUSTOMER_DIM is one dimension of a star schema. Target That Combines Geographic

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.