Excellent training on all software/erp courses from bigclasses by experience faculty. in Hyderābād

Data stage Course Details

Datastage-modules

Contains overview of the data stage components and modules with screenshots.

Designing jobs - Data stage palette

A list of all stages and activities used in Datastage

Extracting and loading data - ODBC and ORACLE stages

Description and use of the ODBC and ORACLE stages (ORAOCI9) used for data extraction and data load.

Covers ODBC input and output links, Oracle update actions and best practices.

Extracting and loading data - sequential files

Description and use of the sequential files (flat files, text files, CSV files) in data stage.

Transforming and filtering data

Use of transformers to perform data conversions, mappings, validations and refining.

Design examples of commonly used data stage jobs.

Performing lookups in Datastage

Hash files and database stages as a lookup source.

Implementing ETL process in Datastage

A step by step guide on how to implement the ETL process efficiently in Datastage.

Contains tips on how to design and run a set of jobs executed on a daily basis.

SCD implementation in Datastage

Illustrates how to implement SCD's (slowly changing dimensions) type

1,2,3,4 in Datastage, contains job designs, screenshots and sample data.

Datastage jobs real-life solutions

A set of examples of job designs resolving real-life problems not covered in previous lessons