Datastage:

COURSE INTRODUCTION

DataStage is metadata-driven and this is the best thing about it. To get faster solutions and provide the data access and reports faster ,DataStagehas many set of options .It is an ideal tool for data integration projects – such as data warehouses, data marts and system migrations as well.DataStageis developed since years and has developed a lot technology wise and is considered as a very powerfool tool. It has the capability to extract data from any sort of source, modify it or clean the data with its capability of transformation and can load into any target.

Datastageand Informaticaare almost the same tools and are very powerful ETL tools . Both perform the same activity and in the same pattern . Like for example – Performance, maintainability, learning curve are all same and can be compared. Datastagehas the functionality of  drag and drop i.e a stage within in one canvas area for a pipeline source-target job.
Mapplets and Worklets are the fucntions in Informaticawhich provides ease of re-usability in case if mappings and workflows are to be reused.This really improves the performance
DataStageprovdes similar re-usability via the containers(local&shared). User need to copy, complie and run the job or workflow to reuse it .

There are some myths about this tool functionality and DataStage is often considerd as  a:

• For designing databased ,Datastage is considered as a Data Modeling tool .
• Data Discovery/Profiling tool .
• Can be considered as a Reporting Tool as it transfers the data into a defined structure which can then be used as a reporting source .Reports on data cannot be produced by Datastagetool .

Have a look at the workingof DataStage :

The design paradigm of DataStage is simplicity, to design an ETL task, you draw “the High Level Picture” – a picture reflecting the sources of data, targets of the data and the processing that the data has to undergo. Datastage reads the complicated files and that too in depth . Say as for example a simple design may read data from a text file, and then change the data formats ,executive summarization of the data, and depicit the results into another text file. That’s all which a picture would show. Now- to provide full solution of the story, users need to go in depth and fill in the additional detail information such as – the pathname of the source file, which columns need to be transformed , grouped and aggregated, the pathname of the target file , etc.

The following are the variants in which DataStage is available to be installed

• No parellelism as the server edition runs on a single server.  It makes the code in a language termed as DataStage BASIC.

• Automatic parellism is permitted on SMP or MPP as the enterprise edition runs on an such an architecture It produces Orchestrate shell scripts.
• Enterprise MVS edition is used for mainframe execution.
• Compilation of the data is necessary in DataStageto run it in a correct manner.
• WHY CHOOSE RS TRAININGS FOR LEARNING DATASTAGE ?
• Backened team of RS Trainings is always available to let your queries be answered on mail
• Also personal sessions with the trainer are available offline and online as well in case if any doubts arises or detailed  inquiry is needed about the course.
• Our technical and backend team will be their to assist you even after completion of your training tenure if needed.. RS Trainings team will always be available to resolve your doubts at any point of time.
• RS Trainings with its team of highly professional and real time trainers and a 24/7 available back end time engages itself in providing thorough and detail subject training. Each domain will be not only be explained theoretically but also practical sessions will be conducted
• Our trainers hold experience  of more than 10 years in respective technology and all are real time trainers.
• RS Trainings provides you with recorded videos of each training session to help you revise your topics later in future.  Also, upgraded course materials will be provided to you .