• Instructor: Tom Steven
  • Students: 5657
  • Duration: 10 weeks

Course Information

Info Sphere Data Stage is an IBM ETL Tool that is a part of Information Platforms Solutions. Data Stage in known for using Graphical notation for constructing data integration solutions.

Data Stage is used in organisations to act as an interface between systems. With Data Stage, the users can extract, translate and load data from source to the target.

Data Stage is available in three versions, Enterprise (PX), Server and MVS editions. This product was earlier introduced in the market by VMark which was later taken over by IBM in 2001.

  • An Introduction of Data warehousing
  • purpose of Data warehouse
  • Data ware Architecture
  • OLTP Vs Data warehouse Applications
  • Data Marts
  • Data warehouse Lifecycle
  • SDLC
  • 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
  • Introduction of Extraction , Transformation and Loding
  • Types of ETL tools
  • Key tools in the market
  • Windows server
  • Oracle
  • .NET
  • Datastage 7.5X2 & 8x&9x

Server jobs & Parallel jobs

  • Administrator client
  • Designer client
  • Director client
  • Import/export manager
  • Multi client manager
  • Console for IBM imformation server
  • Web console for IBM imformation server

 

  • Datastage Introduction
  • IBM Information server Architecture
  • IBM Data Quality Architecture
  • Enterprise Information Integration
  • Web Sphere DataStage Components

 

  • 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
  • Oracle Database
  • Dynamic RDBMS
  • ODBC
  • SQL Server
  • Teradata
  • Sequential File
  • Dataset
  • Lookup File set
  • Peek
  • Head
  • Tail
  • Row Generator
  • Column Generator
  • 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
  • About DS Director
  • Validation
  • Scheduling
  • Status
  • View logs
  • Monitoring
  • Suppress and Demote the Warnings
  • Peek view
  • Create Project
  • Delete Project
  • Protect Project
  • Environmental variables
  • Auto purge
  • RCP
  • OSH
  • Commands Execute
  • Multiple Instances
  • Job Sequence Settings
  • 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
  • Data Quality
  • Data Quality Stages
  • Investigate Stage
  • Standardize Stage
  • Match Frequency Stage
  • Reference Match Stage
  • Unduplicated Match Stage
  • Survive Stage

Curriculum is empty

Price

Free
Call Now ButtonCall NowRequest Form