Datastage Online Training.
Enquire.Join and get training by Well Experienced & Certified tutors for your professional Courses.
Watch Sample Session!DATASTAGE COURSE – LEARN @ YOUR CONVENIENCE
Unit – 1: Data Warehouse Fundamentals
-
- 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 Warehouses
- Data warehouse Life cycle
- Metadata management.
Unit – 2: Data Modelling
-
- Introduction to Data Modelling
- Entity Relationship model(E-R model)
- Data Modeling for Data Warehouse
- Dimensions and fact tables
- Star Schema and Snowflake Schemas
- Coverage Tables
- Fact less
Unit – 3: ETL Design process
-
- Introduction to Extraction, Transformation & Loading
- Types of ETL Tools
- What to look for in ETL Tools
- Key tools in the market
- ETL Trends & New Solution Options.
Unit – 4: Data stage installation
-
- Datastage Installation
- Prerequisites to install Datastage
- Installation process.
Unit – 5: Introduction to Data stage version
-
- Datastage Introduction
- IBM Information Server architecture
- DataStage within the IBM Information Server architecture
- Datastage components
- DataStage main functions
- Client components.
Unit – 6: Datastage Administrator
-
- Datastage project Administration
- Editing projects and Adding projects
- Deleting projects
- Global variable setting
- Environment management
- Runtime Column Propagation (RCP)
- Enable Remote Execution of Parallel jobs
- Add checkpoints for sequencer
- NLS configuration
Unit – 7: Datastage Director
-
- Introduction to Datastage Director
- Validating Datastage Jobs
- Executing Datastage jobs
- Job execution status
- Monitoring a job
- Job log view
- Job scheduling.-
- Message Handler Management
- Multiple job compile
Unit 8: Datastage Designer
-
- Introduction to Datastage Designer
- Importance of Parallelism
- Pipeline Parallelism
- Partition Parallelism
- Partitioning and collecting
- Symmetric Multi Processing (SMP)
- Massively Parallel Processing (MPP)
- Partition techniques
- Datastage Repository
- Palette –
- Passive and Active stages
- Job design overview
- Designer work area
- Annotations
- Creating jobs, deleting jobs
- Parameter passing
- Compiling jobs
- Batch compiling
- Validating jobs
- Importing flat file definitions
- Managing the Metadata environment
- Dataset management
- Deletion of Dataset
- Parameter sets
Unit 9: Working with Parallel job stages.
-
- Database stages
- Oracle
- DB2
- Teradata
- ODBC
- Sql Server stage.
- File stagesSequential file
- Dataset
- Processing stages
- Copy
- Filter
- Funnel
- Sort
- Remove duplicate
- Aggregator
- Modify
- Pivot stage
- Lookup
- Join
- Merge
- Difference between look up, join and merge
- Change capture
- Change apply
- Surrogate key generator
- Transformer.
- Debug stages
- Head
- Tail
- Peek
- Column generator
- Row generator
- Restructure stages
- column export
- column import
Unit 10: Advanced stages in Parallel jobs (Version 8.0.1)
-
- Range Lookup process
- Surrogate key generator stage
- Slowly changing dimension stage
- Job performance analysis
- Slowly Changing Dimensions implementation
- Performance tuning.
Unit 11: Job Sequencers
-
- Arrange job activities in Sequencer
- Triggers in Sequencer
- Restability
- Recoverability
- Notification activity
- Terminator activity
- Wait for file activity
- Execute Command activity
- Nested Condition activity
- Routine activity
- Exception handling activity
- User Variable activity
- End Loop activity
Unit 12: WebSphere Quality Stage
-
- About Data Quality
- Datastage Quality stages
- Investigate stage
- Standardize stage
- Unduplicated Match stage