Oracle

Building a Balanced Hardware Configuration Data Warehouse Logical and Physical

Data Warehousing, Business Intelligence, OLAP, and Data Mining Defining Data Warehouse Concepts and Terminology Business, Logical, Dimensional, and Physical Modeling Database Sizing, Storage, Performance, and Security Considerations The ETL Process: Extracting Data The ETL Process: Transforming Data The ETL Process: Loading Data Refreshing the Warehouse Data Materialized Views Leaving a Metadata Trail Data Warehouse Implementation Considerations

Data Warehousing, Business Intelligence, OLAP, and Data Mining Defining Data Warehouse Concepts and Terminology Business, Logical, Dimensional, and Physical Modeling Database Sizing, Storage, Performance, and Security Considerations The ETL Process: Extracting Data The ETL Process: Transforming Data The ETL Process: Loading Data Refreshing the Warehouse Data Materialized Views Leaving a Metadata Trail Data Warehouse Implementation Considerations

Introducing Oracle Forms Developer and Forms Services Creating Forms Modules Working with Data Blocks and Frames Working with Input Items Working with Non Input Items Working with Windows and Canvases Producing Triggers Debugging Triggers Adding Functionality to Items Run-Time Messages and Alerts Query Triggers Validation Navigation Transaction Processing Writing Flexible Code Sharing Objects and Code Using WebUtil to Interact with the Client Introducing Multiple Form Applications

Setting Up and Starting Warehouse Builder Introducing OWB 10g R2 Architecture and Configuration Defining Source Metadata Ensuring Data Quality Using Data Profiling Defining Staging Metadata and Mapping Tables Deriving Data Rules and Running Correction Mappings Defining a Relational Dimensional Model Handling Slowly Changing Dimensions Using Process Flows Deploying, Loading, and Viewing Data Business Intelligence Integration

Understanding Oracle OLAP Concepts and Technology WB OLAP Modeling and Deployment Using Spreadsheet Add-In to Query OLAP Data Managing OWB Life-Cycle Changes ng the Mapping Debugger Managing the Warehouse Builder Environment Creating Experts