Ø 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 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
nice information
ReplyDeletedatastage training in hyderabad