Datastage online training institute in INDIA, Australia,USA,UK,Canada - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Datastage online training institute in INDIA, Australia,USA,UK,Canada

Description:

Datastage Online Training with real time experts at The Best IT HUB Online Training.DataStage is on of the top ETL products on the BI marketplace. The tool enables integration of processing high quantities of the information and the information across multiple systems. Datastage comes with a user friendly graphical frontend to designing occupations which handle collection, validating, transforming and loading information from several sources, including the business applications like PeopleSoft, SAP, Oracle and mainframes, to the data warehouse systems. The program is effective at incorporating meta data on the other side of the information surroundings to maintain analytic interpretations that are consistent. Datastage supplies dependability and information quality for reporting and exact business analysis. – PowerPoint PPT presentation

Number of Views:19

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Datastage online training institute in INDIA, Australia,USA,UK,Canada


1
(No Transcript)
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
  • IT HUB Online Training provides the best
    Softwares training for various Computer IT
    courses through WebEx, Gotomeeting. We are
    providing Datastage Training based on specific
    needs of the learners especially we will give
    innovative one to one Classes which has great
    opportunities in the present IT market. We also
    provides Class room course to contend with
    todays competitive IT world. Learners can grasp
    the technology-subject from our highly
    experienced certified trainers which will be
    helping the students to work in real time
    projects. Learners can choose either regular
    course or fast track classes or weekend Training
    classes. Its proud to be we are one of the top
    leading Datastage online training provider from
    India.

5
Course Description
  • DATA WAREHOUSINGFUNDAMENTALS
  • 1.Introduction of Data warehousing 2.purpose of
    Data warehouse 3.DW Architecture 4.Data warehouse
    vs. OLTP Applications 5.Data Mart 6.Data
    warehouse Lifecycle
  • DATA MODELING
  • 1.Introduction of Data Modeling 2.Entity
    Relationship(ER) Model 3.Fact and Dimension
    Tables 4.Logical Modeling 5.Physical
    Modeling 6.Schemas Star Schema Snowflake
    Schemas 7.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
    Tools 3.Key tools in the ETL market
  • INSTALLATION PROCESS (Datastage)
  • 1.Windows server 2.Oracle 3..NET 4.Datastage
    7.5X2 8x
  • DIFFERENCE
  • 1.Server jobs Parallel jobs

7
(No Transcript)
8
Course Description
  • COMPONENTS IN DATASTAGE
  • 1.Administrator client 2.Designer
    client 3.Director client 4.Import/export
    manager 5.Multi client manager 6.Console for IBM
    Information server 7.Web console for IBM
    information server
  • DATASTAGE DESIGNER
  • 1.About Web Sphere Data stage Designer 2.Partition
    ing Methods 3.Partitioning Techniques 4.Designer
    Canvas 5.Central Storage 6.Job Designing 7.Creatin
    g the Jobs 8.Compiling and Run the Jobs

9
Course Description
  • PARALLEL PALETTE
  • 1.DATABASES STAGES 2.Oracle Database 3.Dynamic
    RDBMS 4.ODBC 5.SQL Server 6.Teradata FILE
    STAGES 1.Sequential File 2.Dataset 3.Lookup File
    set
  • DEV/DEBUG STAGES
  • 1.Peek 2.Head 3.Tail 4.Row Generator 5.Column
    Generator
  • PROCESSING STAGES
  • 1.Slowly changing dimension stage 2.Slowly
    changing dimensions implementation 3.Aggregator 4.
    Copy 5.Compress 6.Expand 7.Filter

10
(No Transcript)
11
Advantages of Datastage
  • Significant ROI (return of investment) over
    hand-coding
  • Learning curve - quick development and reduced
    maintenance with GUI tool
  • Development Partnerships - easy integration with
    top market products interfaced with the data
    warehouse, such as SAP, Cognos, Oracle, Teradata,
    SAS
  • Single vendor solution for bulk data transfer and
    complex transformations (DataStage versus
    DataStage TX)
  • Transparent and wide range of licensing options

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.
  • There is no automated error handling and recovery
    mechanism - for example no way to automatically
    time out zombie jobs or kill locking processes.
    However, on the operator level, these errors can
    be easily resolved.

13
Disadvantages of datastage
  • No Unix Datastage client - the Client software
    available only under Windows and there are
    different clients for different datastage
    versions. The good thing is that they still can
    be installed on the same windows pc and switched
    with the Multi-Client Manager program.
  • Might be expensive as a solution for a small or
    mid-sized company.

14
Contact us on IND 918121311133 USA
1-347-606-2716 Mail Us contact_at_ithubonlinetrain
ing.com
15
(No Transcript)
About PowerShow.com