Data Warehouse Development ToolsDreamtech Press, Sep 20, 2005 - 432 pages The aim of the book is to lay the foundation in using the popular commercial tools for developing data warehouse in a very short time. With illustrative examples and case studies, the complete process of data warehouse development is explained using Informatica, Cognos, Business Objects and DataStage tools. |
Contents
Data Warehousing Development Process | 23 |
Summary | 41 |
Informatica | 53 |
A Case Study | 197 |
Cognos | 251 |
Business Objects | 317 |
Data Stage | 373 |
Acronyms and Abbreviations | 421 |
References and Internet Resources | 429 |
Common terms and phrases
Blaye business intelligence Cancel Apply Help Cancel Fig Cancel Help Fig Categoryname Click on Apply click on OK Cognos Column Name create a session CUSTOMERDIM data marts data warehouse Database Source Name DataStage DEPT DEPTNO DEPTNO numbe dimension table Double click Drag and drop Edit Transformations Employeedimension EMPNO ENAME Filter folder Informatica PowerCenter 12 Lakkalikööri Layout Mappings Transformation looks as shown Lookup main menu Mapping Designer Mappings Transformation Window menu item MOLAP Name Datatype ODBC Data Source OK Cancel Apply OK Cancel Help OLAP Oracle Oracle database Password PMKEY PowerCenter 12 OEM Productdimension Productname RDBMS Relational Connection Browser Repository Manager Repository Server right click ROLAP rows SAL COMM SALESFACT scottolap select the menu shown in Fig Source Analyzer source database object Source Qualifier string Sum of Quantity target table Timedimension Total Amountsold Username varchar Warehouse Designer window opens Workflow Designer Workflow Manager