Best Datastage online training at india,usa,uk,canada

1
Datastage Online Trainingbywww.ithubonlinetraini
ng.com
2
INTRODUCTION

• IT HUB Online Training Institute ensuring
  accomplished carrier in IT Industry. IT HUB
  online training provides best online training for
  all software tools and technologies. We offer
  real time specialists with a successful track
  record in their field of expertise. IT HUB online
  training introduced online training to reach
  worldwide students who wants to build their
  carrier by learning new technologies. We will
  provide online classes to the top corporate
  companies by IT Industrial experts.

3
About Course And Trainers

• Our Trainers are certified and highly skilled in
  their technologies.
• Our Trainers provides online training with real
  time Methodologies.
• We provide sophisticated study material.
• Recorded videos of regular online sessions.
• Excellent Resume Interview tips by IT Experts.

4
Introduction

• DataStage is one of the leading ETL tools for
  creation and maintenance of Data Marts and Data
  Warehouses. DataStage provides us with
  comprehensive set of options to build solutions
  faster and give access to the data and reports
  faster. It is an ideal tool for data integration
  projects such as data warehouses, data marts
  and system migrations as well.

5
Course Description

• DATA WAREHOUSINGFUNDAMENTALS
• 1.Introduction of Data warehousing2.purpose of
  Data warehouse3.DW Architecture4.Data warehouse
  vs. OLTP Applications5.Data Mart6.Data
  warehouse Lifecycle

• 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

6
Course Description

• 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
• DIFFERENCE
• 1.Server jobs Parallel jobs

7
(No Transcript)
8
Course Description

• COMPONENTS IN DATASTAGE
• 1.Administrator client2.Designer
  client3.Director client4.Import/export
  manager5.Multi client manager6.Console for IBM
  Information server7.Web console for IBM
  information server

• DATASTAGE DESIGNER
• 1.About Web Sphere Data stage Designer2.Partition
  ing Methods3.Partitioning Techniques4.Designer
  Canvas5.Central Storage6.Job Designing7.Creatin
  g the Jobs8.Compiling and Run the Jobs

9
Course Description

• PARALLEL PALETTE
• 1.DATABASES STAGES2.Oracle Database3.Dynamic
  RDBMS4.ODBC5.SQL Server6.TeradataFILE
  STAGES1.Sequential File2.Dataset3.Lookup File
  set

• DEV/DEBUG STAGES
• 1.Peek2.Head3.Tail4.Row Generator5.Column
  Generator
• PROCESSING STAGES
• 1.Slowly changing dimension stage2.Slowly
  changing dimensions implementation3.Aggregator4.
  Copy5.Compress6.Expand7.Filter

10
(No Transcript)
11
Advantages of Datastage

• Ability to join data both at the source, and at
  the integration server and to apply any business
  rule from within a single interface without
  having to write any procedural code.
• Common data infrastructure for data movement and
  data quality (metadata repository, parallel
  processing framework, development environment)

12
Disadvantages of datastage

• Big architectural differences in the Server and
  Enterprise edition which results in the fact that
  migration from server to enterprise edition may
  require vast time and resources effort.
• Might be expensive as a solution for a small or
  mid-sized company.

13
Contact us onIND 918121311133USA
1-347-606-2716 Mail Us contact_at_ithubonlinetrain
ing.com
14
(No Transcript)