ibm datastage Training in Hydeabad

ibm datastage Training

 #307, 5th Floor, Liberty Plaza,
opp: Stanza,Himayat Nagar,
Hyderabad - 500029.

Phone No     : 040- 6644 4122
Email           :  info@unitedglobalsoft.com
Website       :  www.unitedglobalsoft.com

Data Warehousing Concepts:

• Introduction to Data Warehousing
• What is Data Warehousing .Who needs Data Warehousing?
• Why Data Warehouse is required?
• Data Warehousing Architecture
• Types of Systems
• OLTP
• OLAP
• Data Warehousing Life Cycle

Data Modeling Concepts

• Source
• Integration Layer
• Staging Area
• Target
• Analysis & Reporting
• ODS

Multi-Dimensional Modeling Concepts

• What is dimension modeling?
• Difference between ER modeling and dimension modeling
• What is a Dimension?
• What is a Fact?
• Start Schema
• Snow Flake Schema
• Difference between Star and snow flake schema
• Fact Table
• Different types of facts
• Dimensional Tables
• Fact less Fact Table
• Confirmed Dimensions
• Junk Dimensions
• Degenerative Dimensions
• What are slowly changing Dimensions?
• Different types of SCD’s

IBM DataStage Contents

• Introduction about Data Stage
• DataStage architecture
• Difference between Server Jobs and Parallel Jobs
• Difference between Pipeline Parallelism and Partition Parallelism
• Partition techniques
• Configuration File
• Difference between SMP/MPP Architecture
• Data stage components (Server components /Client components)

Administrator

• Introduction about Administrator
• Project creation and project properties setup

Designer

• Introduction about Designer
• Repository
• Palette
• Type of Links

File Stages

• Sequential file
• Dataset file
• File set
• Lookup file set
• Difference between Sequential file/Dataset/File set

Database Stages

• Dynamic RDBMS
• Oracle Enterprise
• ODBC Enterprise

Processing Stages

• Aggregate Stage
• Transformer Stage
• Surrogate Generator Stage
• Join Stage
• Merge Stage
• Lookup Stage
• Difference between Join/Lookup/Merge
• Difference between Join/Lookup
• Remove Duplicates
• Switch
• Pivot
• Modify
• Funnel
• Different types of sorting and sort stage.
• Different types of combining and collecting techniques.
• Filter
• External filter
• Difference between filter, External filter and switch stages.
• SCD stage
• Adding job parameters to a job
• Parameter set
• Run time column propagation

Debugging Stage

• Head
• Tail
• Pea
• Row Generator
• Column Generator
• Sample

Data stage Director

• Introduction to Data stage Director
• Job Status View
• View logs
• Scheduling