IBM DataStage
Data Stage Training Course
Datastage training with 100% realtime project and real time scenarios.
Course Content:
- DATA WAREHOUSE FUNDAMENTALS
- An Introduction of Data warehousing
- purpose of Data warehouse
- Data ware Architecture
- OLTP Vs Data warehouse Applications
- Data Marts
- Data warehouse Lifecycle
- SDLC
- DATA MODELING
- Introduction of Data Modeling
- Entity Relationship Model
- Dimensions and Fast Tables
- Logical Modeling
- Physical Modeling
- Schemas Like Star Schema & Snowflake Schemas
- Fact less Fact Tables
- COMPONENTS IN DATASTAGE
- Administrator clint
- Designer client
- Director client
- Import/export manager
- Multi-client manager
- Console for IBM imformation server
- Web console for IBM imformation server
- INTRODUCTION TO IBM WEB SPHERE DATASTAGE
- Datastage Introduction
- IBM Information server Architecture
- IBM Data Quality Architecture
- Enterprise Information Integration
- Web Sphere DataStage Components
- DATASTAGE DESIGNER
- About Web Sphere DataStage Designer
- Partitioning Methods
- Partitioning Techniques
- Designer Canvas
- Central Storage
- Job Designing
- Creating the Jobs
- Compiling and Run the Jobs
- Exporting and importing the jobs
- Parameter passing
- System (SMP) & Cluster system(MPP)
- Importing Method(Flat file, Txt, Xls and Database files)
- OSH Importing Method
- Configuration file
7.FILE STAGES
- Sequential File
- Dataset
- Lookup File set
- DEV/DEBUG STAGES
- Peek
- Head
- Tail
- Row Generator
- Column Generator
- PROCESSING STAGES
- Slowly changing dimension stage
- Slowly changing dimensions implementation
- Aggregator
- Copy
- Compress
- Expand
- Filter
- Modify
- Sort
- Switch
- Lookup
- Join
- Marge
- Change Capture
- Change Apply
- Compare
- Difference
- Funnel
- Remove Duplicate
- Surrogate Key Generator
- Pivot stage
- Transformer
- CONTANERS
- Shared Containers
- Local Containers
- DS-DIRECTOR
- About DS Director
- Validation
- Scheduling
- Status
- View logs
- Monitoring
- Suppress and Demote the Warnings
- Peek view
- DATASTAGE ADMINISTRATOR
- Create Project
- Delete Project
- Protect Project
- Environmental variables
- Auto purge
- RCP
- OSH
- Commands Execute
- Multiple Instances
- Job Sequence Settings
- JOB SEQUENCE AREA
- Job Activity
- Job sequencer
- Start loop Activity
- End loop Activity
- Notification Activity
- Terminator Activity
- Nested Condition Activity
- Exception handling Activity
- Execute Command Activity
- Wait for file Activity
- User variable Activity
- Adding Check Points
- Restart able
Highlights in our training:
- Very in depth course material with real time scenarios.
- We are providing class with highly qualified trainer.
- We will provide class and demo session at student flexible timings.
- In training case studies and real time scenarios covered.
- We will give 24*7 technical supports.
- Each topic coverage with real time solutions.
- We are providing normal track,weekend,fast track classes.
- We will give every recorded session for play later.
- We are giving placement support by multiple consultancies in INDIA, USA, Australia, UK etc.
- We are providing certification oriented trainings with 100% pass guarantee.
- We will give full support while attending the interviews and contact me any time after completion of the course.
KEY SERVICE
- FAQS
- Covering DBA concepts
- Concentration on performance tuning
- Real time scenarios
- Certification guidance
- Resume preparation
- Sample resumes
- Interview & certification FAQS
- How to face the interview
- Class notes which is useful for who is trying for job
- Project preparation