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

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:52

less

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 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
  • 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 onIND 918121311133USA
1-347-606-2716 Mail Us contact_at_ithubonlinetrain
ing.com
15
(No Transcript)
Write a Comment
User Comments (0)
About PowerShow.com