|
DATA WAREHOUSE FUNDAMENTALS
An introduction to Data Warehousing
Purpose of Data Warehouse
Data Warehouse Architecture
Operational Data Store
OLTP Vs Warehouse Applications
Data Marts
Data marts Vs Data Warehouses
Data Warehouse Life cycle.
DATA MODELING
Introduction to Data Modeling
Entity Relationship model (E-R model)
Data Modeling for Data Warehouse, Normalization process
Dimensions and fact tables
Star Schema and Snowflake Schemas.
ETL DESIGN PROCESS
Introduction to Extraction, Transformation & Loading
Types of ETL Tools
Key tools in the market.
INTRODUCTION TO DATA STAGE VERSION 7.5X2 & 8.1& 8.5
Data stage introduction
IBM information Server architecture
Data stage components
Data Stage main functions
Client components- Adding different Servers to our workspace.
DATA STAGE ADMINISTRATOR
Data stage project Administration
Editing projects and Adding Projects
Deleting projects Cleansing up project files
Environmental Variables
Environment management
Auto purging
Runtime Column Propagation(RCP)
Add checkpoints for sequencer
NLS configuration
Generated OSH (Orchestra Engine)
System formats like data, timestamp
Projects protect - Version details.
DATA STAGE DIRECTOR
Introduction to Data stage Director
Validating Data stage Jobs
Executing Data stage jobs
Job execution status
Monitoring a job
Job log view
Job scheduling
Creating Batches
Scheduling batches.
|
