Datastage Online Training
USA : +1 732 325 1626
IND : +91 800 811 4040
E-mail Id : info@onlinetrainershub.com
  • Why DataStage ?

    Data Stage is an Umbrella integrated solution with features like profiling, Cleansing, Extraction, Transformation, De-Identification and Loading. Can join at any level and apply any business transformation rule without any procedural code.

  • About DataStage

    Data Stage is a powerful Data Integration tool acquired by IBM in 2005. It is capable of integrating data across different and high volume data sources and target applications.  It simplifies extended metadata management and enterprise connectivity.

  • Our Services

    Organized course study material Resume and Interview preparation Assistance after the course Course overview with FAQ’s

Datastageonlinetrainings.com is one of the best online software training institutes. All the trainers at Datastageonlinetrainings.com are very skilled and certified professionals with many years of real time experience in IT industry. We handle each and every student very carefully to deliver the best Data Stage online training experience.

We provide the students with many services to make everyone more confident in their career. Some of the services are as follows:

  • Fully designed course study material with real-time scenarios
  • All the sessions at your flexible time
  • 24X7 Remote server access and support
  • Career oriented training with interview based FAQ’s
  • We provide normal track , weekly and fast track sessions
  • Practice sessions will be provided
  • Project support
  • We help in making of resume
  • Support after the course completion
  • Customized curriculum
  • Our trainer will help you in Software installation
  • Recorded session videos can be provided after the course

Course Overview

Data Stage is an ETL tool which is used to perform the data to load into data warehousing. ETL (Extraction, Transformation and Loading) tools extract data from multiple non-coherent systems, cleanse, merge and load the data into multiple target systems and can connect to major databases like Teradata, Oracle, SQL server, DB2, SAP and Siebel etc.

The Data Stage interfaces are defined as jobs, configured in such a way that they can work on a single server and also on multiple servers in a grid architecture. The DS Engine stores all the metadata, runtime information and as well as the jobs executions.

Data Stage supports both UNIX and Windows servers. The server is the place where the actual jobs reside and run. Earlier versions of Data Stage were only supported by UNIX servers. The server is connected by Data Stage Client which is based on Windows application with tools to prepare a Data Stage job.

Work in Data Stage is classified into one or more work areas called “Projects”. Every project has its own individual local Repository where its designs, technical and process metadata are stored. You can find the projects created in dshome directory in the subfolder of projects which is a default directory.

There are 3 Data Stage components:

  • Data Stage Administrator
  • Data Stage Director
  • Data Stage Designer

Data Stage Administrator:

The following are the functions performed by the Administrator

  • Adding, deleting and moving of projects
  • Managing user permissions for projects
  • Purge job log files
  • Controlling timeout interval on the engine
  • Tracing the engine activities
  • Issuing DA Engine commands from the Administration Client
  • Configuring parallel processing jobs settings
  • Creating/setting environmental variables
  • Setting the job parameter defaults

Data Stage Designer:

  • Jobs are designed and developed using the graphical design tool
  • Different Stages like General, File, Processing stages and Database are used while developing the jobs
  • Table definitions are carried directly from the data source or data warehouse tables
  • Jobs are compiled by the designer and checks for any errors like key expressions, transforms, primary inputs, reference outputs etc.
  • Imports or exports the jobs or projects from various environments
  • Parallel jobs, mainframe jobs and server jobs can be created using the designer
  • Custom routines can be created by the designer
  • Many jobs can be compiled and provided the report after the compilation is completed

Data Stage Director:

  • Run, Monitor, Schedule and validate jobs will be done by the Data Stage Director
  • Job log displays the selected log file
  • Director will reset the job if the status is aborted or stopped before running
  • Enables the execution time of the jobs
  • Director has ability to clean up the resources
  • Displays the current job status like running, compiled, finished, aborted and not compiled
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube