data stage Online Training Institute in India,USA,UK,Canada.

1
DATA SATGE TRAINING

• By
• HYDERABADSYS ONLINE TRAINING

2
Data Stage Online Training Course Content

• Datastage Online Training Course Content
• 1.Introduction of Data warehousing2.purpose of
  Data warehouse3.DW Architecture4.Data warehouse
  vs. OLTP Applications5.Data Mart6.Data
  warehouse Lifecycle

3

• DATA MODELING
• 1.Introduction of Data Modeling2.Entity
  Relationship(ER) Model3.Fact and Dimension
  Tables4.Logical Modeling5.Physical
  Modeling6.Schemas Star Schema Snowflake
  Schemas7.Fact less Fact Tables

4
Data Stage Online Training Course Content

• PROCESS ETL (EXTRACTION, TRANSACTION LOAD)
• 1.Introduction of Extraction , Transformation
  and Loading (ETL)2.Types of available ETL
  Tools3.Key tools in the ETL market
• INSTALLATION PROCESS (Datastage)
• 1.Windows server2.Oracle3..NET4.Datastage
  7.5X2 8x

5

• DIFFERENCE
• 1.Server jobs Parallel jobs
• COMPONENTS IN DATASTAGE
• 1.Administrator client2.Designer
  client3.Director client4.Import/export
  manager5.Multi client manager

6
Data Stage Online Training Course Content

• INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND
  QUALITY STAGE 8X
• 1.Introduction to Datastage2.IBM Information
  server Architecture3.IBM Data Quality
  Architecture4.Enterprise Information
  Integration5.Web Sphere Data stage Components

7
Data Stage Online Training Course Content

• DATASTAGE DESIGNER
• 1.About Web Sphere Data stage Designer2.Partitio
  ning Methods3.Partitioning Techniques4.Designer
  Canvas5.Central Storage6.Job Designing7.Creatin
  g the Jobs8.Compiling and Run the
  Jobs9.Exporting and importing the
  jobs10.Parameter passing11.System(SMP)
  Cluster system(MPP)12.Importing Metho

8

• Different types of sorting and sort stage.
• Different types of combining and collecting techni
  ques.
• Filter
• External filter
• Difference between filter, External filter and swi
  tch stages.
• Change Capture stage
• Job Parameters  Parameter set
• Run time column propagation

9

• Sequencer Jobs
• Debugging Stage  
• Head
• Tail
• Peak
• Row Generator
• Column Generator
• Sample

10
(No Transcript)
11
(No Transcript)