IBM DATASTAGE ONLINE TRAINING

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

If you want to know more about IBM DATASTAGE ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com