Datastage Course details – Syllabus

INTRODUCTION TO DATAWARE HOUSE (DW)
DATA WAREHOUSINGFUNDAMENTALS
Introduction of Data warehousing
✔purpose of Data warehouse
✔DW Architecture
✔Data warehouse vs. OLTP Applications
✔Data Mart
✔Data warehouse Lifecycle
DATA MODELING
✔Introduction of Data Modeling
✔Entity Relationship(ER) Model
✔Fact and Dimension Tables
✔Logical Modeling
✔Physical Modeling
✔Schemas – Star Schema & Snowflake Schemas
✔Fact less Fact Tables
PROCESS – ETL (EXTRACTION, TRANSACTION & LOAD)
✔Introduction of Extraction , Transformation and Loading (ETL)
✔Types of available ETL Tools
✔Key tools in the ETL market
INSTALLATION PROCESS (Datastage)
✔Windows server
✔Oracle
✔.NET
✔Datastage ✔5X2 & 8x
DIFFERENCE
✔Server jobs & Parallel jobs
COMPONENTS IN DATASTAGE
✔Administrator client
✔Designer client
✔Director client
✔Import/export manager
✔Multi client manager
✔Console for IBM Information server
✔Web console for IBM information server
INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X
✔Introduction to Datastage
✔IBM Information server Architecture
✔IBM Data Quality Architecture
✔Enterprise Information Integration
✔Web Sphere Data stage Components
DATASTAGE DESIGNER
✔About Web Sphere Data stage 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
PARALLEL PALETTE
✔DATABASES STAGES
✔Oracle Database
✔Dynamic RDBMS
✔ODBC
✔SQL Server
✔Teradata
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
✔Restartable
IBM WEB SPHERE QUALITY STAGE
✔Data Quality
✔Data Quality Stages
✔Investigate Stage
✔Standardize Stage
✔Match Frequency Stage
✔Reference Match Stage
✔Unduplicated Match Stage
✔Survive Stage
✔Viewing audit details in operational DASHBOARD reports

Leave a Reply

Your email address will not be published.