Jump to content

Datastage online training by real time employees @ Optimus


david_optimus

Recommended Posts

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]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...