DataStage

What is Datastage?

• Design jobs for Extraction, Transformation, and Loading (ETL)
• Ideal tool for data integration projects – such as data warehouses, data marts, and system migrations
• Import, export, create and managed metadata for use within jobs
• Schedule, run and monitor jobs all within DataStage
• Administer your DataStage development and execution environments

What Is a Job?

• Executable DataStage program
• Created in DataStage Designer, but can use components from Manager
• Built using a graphical user interface
• Compiles into Orchestrate shell language (OSH)

Job Development Overview:

• In Manager, import metadata defining sources and targets
• In Designer, add stages defining data extractions and loads
• And Transformers and other stages to defined data transformations
• Add links defining the flow of data from sources to targets
• Compiled the job
• In Director, validate, run, and monitor your job

What are Job controlling Options?

Manually write job control

• The code generated in Basic
• Use the job control tab on the job properties page
• Generates basic code which you can modify

Job Sequencer

• Build a controlling job much the same way you build other jobs
• Comprised of stages and links
• No basic coding

What are Aggregator Functions:

• Sum
• Min, max
• Mean
• Missing value count
• Non-missing value count
• Percent coefficient of variation

Wrappers vs. Buildop vs. Custom:

• Wrappers: Wrappers good if you cannot or do not want to modify the application and performance is not critical.
• Buildops: Buidops good if you need custom coding but do not need dynamic (runtime-based) input and output interfaces.
• Custom (C++ coding using framework API): Custom is good if you need custom coding and need dynamic input and output interfaces

What are Different Roles In Datatage?

• Administrator – add/delete projects, set defaults
• Manager – import metadata, backup projects
• Designer – assemble jobs, compile, and execute
• Director – execute jobs, examine job run logs

What Will We Learn In Datastage Training?

• Design the jobs that extract, integrate, aggregate, load, and transform the data for your data warehouse or data mart.
• Create and reuse metadata and job components.
• Run, monitor, and schedule these jobs.
• Administer your development and execution environments.

Who should go for this DataStage training Course?

• Software developers, architects, and other professionals
• Data analysts and ETL Developers
• Those looking for a career in Business Intelligence

What Are The Prerequisites To Learn Datastage?

Our Experienced trainers will teach from basics, if you have a basic idea of relational databases is an added advantage for this course.

Scheduling Demo With Trainer:

If you would like to take the online demo for Datastage trainer can you please make an inquiry or fill the form for demo registration, one of our executives will arrange a meeting with the expert trainer.

Course Finished Certificate :

After finish, the course we provide Datastage course finished certificate of kits technologies looks like