DWH ETL /
Datastage

Datastage

DataStage Online Training

What is DataStage

Datastage is a central file store with three added benefits:
Security controls that allow researchers to have a “private” area only accessible to themselves and the group leader, and “shared” and “collaborative” areas to put files of use to the whole research group.
Web interface allowing users to annotate their files, and access data from outside their “home” computer.
The option to send data to a repository for permanent storage.

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn DataStage Online Training.

  • 1

    Introduction about Data Stage

    20:56
  • 2

    Datastage Basic Concepts

    20:56
  • 3

    Difference between Server Jobs and Parallel Jobs

    20:56
  • 4

    Difference between Pipeline Parallelisms

    20:56
  • 5

    Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,
    Range, DB2, Auto)

    20:56
  • 6

    Configuration File

    20:56
  • 7

    Difference between SMP/MPD architecture

    20:56
  • 8

    Data Stage Components (Server components/Client Components)

    20:56
  • 9

    Package Installer

    20:56
  • 1

    Creating project, Editing project and Deleting project

    20:56
  • 2

    Permissions to user

    20:56
  • 3

    .apt Config file

    20:56
  • 4

    Environment variable creation, permission

    20:56
  • 1

    Introduction to Data stage Director

    20:56
  • 2

    Job status View

    20:56
  • 5

    Batches Creation

    20:56
  • 1

    Introduction about Designer

    20:56
  • 6

    Sequential File

    20:56
  • 8

    Lookup file set

    20:56
  • 9

    Difference between Sequential file/Dataset/File set

    20:56
  • 10

    Database stages

    20:56
  • 12

    Oracle Enterprise

    20:56
  • 13

    ODBC Enterprise

    20:56
  • 14

    Stored Procedure

    20:56
  • 1

    Change Capture (Caption)

    20:56
  • 3

    Difference Stage

    20:56
  • 4

    Aggregate Stage

    20:56
  • 5

    Transformer Stage

    20:56
  • 6

    Surrogate Generator Stage

    20:56
  • 7

    Join Generator Stage

    20:56
  • 8

    Merge Generator Stage

    20:56
  • 9

    Lookup Generator Stage

    20:56
  • 10

    Difference between join/Lookup/Merge

    20:56
  • 11

    Difference between join/Lookup

    20:56
  • 12

    Remove Duplicates

    20:56
  • 5

    Column Generator

    20:56
  • 1

    Introduction About Data stage Manager

    20:56
  • 2

    Importing the Job

    20:56
  • 3

    Exporting the Job

    20:56
  • 4

    Importing Table Definition

    20:56
  • 5

    Importing Flat File Definition

    20:56
  • 1

    Difference between Local Container and Shared Container

    20:56
  • 2

    Local Container

    20:56
  • 3

    Shared Container

    20:56
N/A