| |
DataStage 8.1
|
| |
UNIT 1 |
| |
|
| |
Data Warehousing Concepts
- About Data Warehouse& Data Warehousing
- Active Warehouse & Passive Warehousing
- Data Warehouse Usages Evolution
- OLTP, DSS, OLAP & OLCP
- SDLC(DWD life cycle)
- Schema Types(star, Snow etc...)
- Characteristics of Dimensions & Fact Tables
- ETL Process & Cleansing (parsing,Correcting,Standadize,Matching and Consolidate)
- ER & Dimensional Model Overview
|
| |
|
| |
UNIT 2 |
| |
|
| |
Introduction To Datastage
- History and Features
- About Ascential suite
- Traditional Batch Processing
- Partition & Pipeline parallelism
- Partitioning & Re-Partitioning Techniques
- Combinality, Combining & Collecting Techniques
- IBM Web Sphere DataStage 8 Architecture
- Configuration File & Node Components
|
| |
|
| |
UNIT 3 |
| |
|
| |
About DataStage 8.1
- Differences between 7.5X2 & 8.1
- Parallel Processing environments (SMP,MPP etc..)
- Topologies ( Two tier, Three tier etc..)
- Information Analyzer Overview
- DataStage & DataStage Quality stage overview
- Web Console for Information Server
|
| |
|
| |
UNIT 4 |
| |
|
| |
DataStage Jobs & Stages
- Differnce between server & parallel jobs
- Overview of Parallel jobs , Server jobs, Mainframe jobs, migration jobs and job sequencing jobs
- Repository, DS Designer toolbar & Palette
- Active and Passive stages
- palette Customization
- About link Makers
- Frame Work Operators
|
| |
UNIT 5
|
| |
|
| |
Working with file stages
- Sequential file & stage rules
- Data set & Format
- Fileset & lookup fileset
- differences between Dataset, fileset & seq file
- Complex flat file
|
| |
UNIT 6
|
| |
|
| |
Development / Debug stages and Stub Stages
- Row and Column Generator
- Head, Tail and Sample
- Peek
- Write Range map
- Copy stage
|
| |
UNIT 7 |
| |
|
| |
Working with relational Stages
- Enterprise and Plug-in Stages
- Oracle ,SQl Server
- TERADATA ( Fast load, Multi Load & TPump )
- ODBC & ODBC Connector
- Dynamic RDBMS
|
| |
UNIT 8 |
| |
|
| |
DataStage 8 New features
- Data Connections
- Parameter set
- SQL Builder
- Quick Find & Advanced find
- Performance Analysis
- Resource Analysis
- Import and Export
|
| |
UNIT 9 |
| |
|
| |
Processing Stages
Sorting
- In stage sort & Stage sort ( Key Change & Cluster )
Combining ( Horizontal & Vertical ) & Funnelling
- Join, Lookup( Normal, Sparse, Range & case less ) and Merge
- 15 differences between Join, Lookup and Merge
- Aggregator stage
- Remove Duplicate Stage
- Funnel Stage
Filtering Methods
- Filter stage, Switch Stage & External Filter stage
- Constraints
Data Transformation with Transformer & Modify stage
- Basic transfomer Vs Transformer
- External Functioins & Macros
- Stage Variables & System Variables
- Execution Order
- External Before and After Sub Routines
- Modify Stage
SCD Implementations & Surrogate Key Generation
- SCD Type-1, Type-2 implementation in 7.5X2
- Change Capture and Change Apply Stages
- SCD Type-1, Type-2 Implementation in 8.0.1
- SCD Stage
- Surrogate Key Stage
Other Stages
- FTP stage
- Pivot stage
- Compress & Expand
- Encode & decode Stage
- Generic Stage
Real Time & Restructing Stages
- XML Input & XML output stage
- Column Export and Column Import Stage
|
| |
UNIT 10 |
| |
|
| |
Quality Stages
- Parsing, Correcting, Standardise, matching & Consolidate
- Investigate Stage
- Standardize Stage
- Match Frequency Stage
- Unduplicate Match stage
- Reference Match
- Survive Stage
- WAVES
- MNS
|
| |
UNIT 11 |
| |
|
| |
Performance Tuning tips
- Important Environment Variables
- Partitioning Techniques
- Techniques for Job Development
- Monitor
- Job Score
- Containers
|
| |
UNIT12 |
| |
|
| |
Job Control & Job Sequencing
- Introduction to JCL Scripting
- Job Sequencing ( Run Stages, Error Handling, Flow Control Stages )
- Batch Jobs
|
| |
UNIT 13 |
| |
|
| |
DataStage Director
- Message Handling ( Job Level and Project Level )
- Schedule / Validate / Run
- Views
- Unlocking and Customize
|
| |
UNIT 14 |
| |
|
| |
Web Console for IBM Information Server
- Security Services
- Session Services
- logging Services
- Scheduling Services
- Domain Management
- Reporting Services
|
| |
UNIT 15 |
| |
|
| |
DataStage Adminstrator
- ADD, Delete Projects
- Run time Column Propagation
- Adding Entirs and the Tools Menu
- Setting job parameter Default
- Tracing Server activity
- DataStage Engine Commands
|
| |
UNIT 16 |
| |
|
| |
Information Analyzer
- Analyzer Configuration
- Column Analysis
- Primary Key Analysis
- Foreign Key Analysis
- Cross domain Analysis
- Base line Analysis
|
| |
UNIT17 |
| |
|
| |
Project Overview
- Data Warehouse Development Life Cycle
- ETL Activities, Role & Responsibilities
- Understanding Mapping Document
- Namming Conventions
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
