Ø Data Warehouse Fundamentals (3 days)
ü 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 WarehousesData Warehouse
Life cycle.
Ø Data Modeling ( 2days) Introduction to Data Modeling Data Modeling for Data Warehouse,
Normalization process Dimensions and
fact tables Star Schema and Snowflake Schemas.
Ø ETL Design Process (2days) 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 (1day)
ü 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 (1day)
ü 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 Generated OSH (Orchestra Engine) System formats like
data, timestamp Projects protect – Version details
No comments:
Post a Comment