Datastage online training by real time employees @ Optimus

[david_optimus]

DATAWAREHOUSING CONCEPTS

Introduction to Data Warehousing

 What is Data Warehousing?
 Who needs Data Warehousing?
 Why Data Warehouse is required?
 Types of Systems
(i) OLTP (ii) OLAP
 Maintenance of Data Warehouse
 Data Warehousing Life Cycle

Data Warehousing Architecture
 Source
 Integration Layer
 Staging Area
 Target
 Analysis & Reporting
 ODS

Multi-Dimensional Modeling
 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
 Unconfirmed dimensions
 Junk Dimensions
 Monster dimensions
 Degenerative dimensions
 What are slowly changing dimensions?
 Different types of SCD’s


IBM WEBSPHERE DATA STAGE AND QUALITY STAGE  VERSION 8.0.1
Contents
• Introduction about Data Stage
• Difference between Data Stage 7.5.2 and 8.0.1
• What’s new in Data Stage 8.0.1?
• What is way ahead in Data Stage?
• IBM Information Sever architecture
• Datastage within the IBM Information Sever architecture
• Difference between Server Jobs and Parallel Jobs
• Difference between Pipeline Parallelism and Partition Parallelism
• Partition techniques (Round Robin, Random,
- Hash, Entire, Same, Modules, Range, DB2, Auto)
• Configuration file
• Difference between SMP/PMP(Cluster) Architecture
• Data stage components (Server components /Client  components)
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
• Overview of iway, Classic federation and netezza
• Database stages
 Dynamic RDBMS
 Oracle Enterprise
 ODBC Enterprise
 Stored Procedure


Processing Stages

• Change Capture
• Compare Stage
• Difference Stage
• Aggregate Stage
• Transformer Stage
• Difference between basic transformer and transformer
• Surrogate Generator Stage
• Join Stage
• Merge Stage
• Lookup Stage
• Difference between Join/Lookup/Merge
• Difference between Join/Lookup
• Remove Duplicates
• Switch
• Pivot
• Modify
• Funnel
• Generic stage
• 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
• Encode and decode stages
• FTP stage
• Adding job parameters to a job
• Parameter set
• Difference between partitioning and re partitioning
• Run time column propagation
• Schema files
Debugging Stage 
                                                                                                                                                       
• Head                                                                         
• Tail                                                                         
• Pea
• Row Generator                                                       
• Column Generator
• Sample
                                                                   
Containers

• Difference between Local Container and Shared Container
• Local Container
• Shared Container

Job Sequencers

• Arrange job activities in sequencer
• Triggers in Sequencer
• Notification activity
• Terminator Activity
• Wait for file activity
• Start loop activity
• Execute command activity
• Nested Condition activity
• Routine activity
• Exception handing activity
• User variable activity
• End loop activity
• Adding Checkpoints

Data stage Director
• Introduction to Data stage Director
• Job Status View
• View logs
• Scheduling
• Batches Creation
• Cleaning resources using Administrator

Web sphere Manager in Designer
• Introduction about Data stage Manager
• Importing the Job
• Exporting the Job
• Importing Table Definition
• Different types of table definitions and their differences.
• Importing Flat File Definition
• Routines
• Dataset management and ORCHADMIN
• Quick search and advanced search

Data stage Administrator
• Creating project, Editing project and Deleting project
• Permissions to user
• Different kinds of variables in Data Stage
• Cleaning resources using Administrator

Web sphere Quality Stage
• What is Date Quality and why do we for data quality?
• Integration of Data Quality in Data Stage?
• Data stage Quality stages
• Investigate stage
• Standardize stage Match Frequency stage
• Unduplicate Match stage
• Reference Match stage
• Survive stage
• Standardized rule sets.
• Components of Standardized rule sets.
• Match designer
• WAVES

Contact : David
PH : +91-810-680-5188
E : [email protected]