Fundamentals of Data Transformation (DS TX)

Please Note: This class is subject to a ten percent increase. Please contact a TrainingPage representative for verification of price increase.

Description:

Please see SW110, the updated Transformation Extender course, for course information and schedule

This course was formerly course numbers FICT / MC600 / DS636.

Get an in-depth, hands-on experience on the use of the DataStage TX Design Studio using the Fundamentals of Data Transformation. Learn the basic instruction on the use of the DataStage TX Design Studio components used to define business processes and transform data for use on one system to another. The components covered include the Type Designer, Map Designer, and resource registry. Complete hands-on exercises to help you utilize the skills acquired. Emphasis is placed on preparing you for mapping project implementation using the DataStage TX Design Studio.

Course Materials

The course materials address Fundamentals of Data Transformation (DS TX) - Version 7.x.

Hands-On Labs

Several labs are included throughout the delivery to address and reinforce the skills discussed.

Audience:

This is a basic course for programmer or analysts and business systems analysts who implement data integration and transformation solutions using DataStage TX products.

Objectives:

• Identify the Design Studio and Integration Broker components
• Implement the Fundamentals of Data Transformation using the Type Designer and Map Designer

Prerequisites:

You should have a solid understanding of data formats and processing logic. A proficiency in using Microsoft Windows is recommended.

Topics:

• Defining data structures
• Defining data properties
• Defining data components
• Validating data definition
• Building in additional validation
• More about mapping
• Functional maps
• Functional Map Wizard
• More efficient type definitions
• Error handling
• Map optimization
• Map execution
• Text file importer