Data Stage

0 STUDENTS ENROLLED

    Introduction

    Data Stage Online Training A data extraction and transformation program for Windows NT/2000 servers that is used to pull data from legacy databases, flat files and relational databases and convert them into data marts and data warehouses. Formerly a product from Essential Software Corporation, which IBM acquired in 2005, Data Stage became a core component of the IBM Web Sphere Data Integration suite. we provide more information from below.

    Data Stage Course Content:

    1.Contents

    • Introduction about Data Stage
    • Difference between Server Jobs and Parallel Jobs
    • Difference between Pipeline Parallelisms
    • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
    • Configuration File
    • Difference between SMP/MPD architecture
    • Data Stage Components (Server components/Client Components)
    • Package Installer

    2.Data Stage Administrator

    • Creating project, Editing project and Deleting project
    • Permissions to user
    • .Apt Config file
    • Environment variable creation, permission

    3.Data stage director

    • Introduction to Data stage Director
    • Job status View
    • View logs
    • Scheduling
    • Batches Creation

    4.Designer

    • Introduction about Designer
    • Repository
    • Palatte
    • Types of Links
    • File Stages
    • Sequential File
    • Data set File
    • Lookup file set
    • Difference between Sequential file/Dataset/File set
    • Database stages
    • Dynamic RDBMS
    • Oracle Enterprise
    • ODBC Enterprise
    • Stored Procedure

    5.Processing stages

    • Change Capture (Caption)
    • Compare stage
    • Difference Stage
    • Aggregate Stage
    • Transformer Stage
    • Surrogate Generator Stage
    • Join Generator Stage
    • Merge Generator Stage
    • Lookup Generator Stage
    • Difference between join/Lookup/Merge
    • Difference between join/Lookup
    • Remove Duplicates
    • Switch
    • Pivot
    • Modify
    • Funnel

    6.Debugging stage

    • Row Generator
    • Column Generator
    • Sample
    • Job Parameters

    7.Manager

    • Introduction About Data stage Manager
    • Importing the Job
    • Exporting the Job
    • Importing Table Definition
    • Importing Flat File Definition
    • Routines

    8.Containers

    • Difference between Local Container and Shared Container
    • Local Container
    • Shared Container

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month, 1 week
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details


      * Required

      Job Support

        Your Details


        * Required

        Course Features

        Live Instructor-led Classes

        This isn't canned learning. Its dynamic, its interactive, its effective

        Expert Educators

        Only the best or they're out. We are constantly evaluating our trainers

        24&7 Support

        We never sleep. Need something answered at 3 am? No Problem

        Flexible Schedule

        You don't learn as per our calendar. We work according to yours.

        Customized Training's

        The most part self-managed and adaptable to suit a person's particular adapting technology needs

        Priority Based Training's

        Real-time Scenario based Assignments and Case Studies

        COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED