DataStage Manager allows users to manage metadata for DataStage jobs. It includes branches for data elements, jobs, routines, shared containers, stage types, table definitions, and transforms. Metadata can be imported from files, created manually in Manager, or loaded from a passive stage into a job. Table definitions specify the format of data files and tables and can be imported from sequential files.
DataStage Manager allows users to manage metadata for DataStage jobs. It includes branches for data elements, jobs, routines, shared containers, stage types, table definitions, and transforms. Metadata can be imported from files, created manually in Manager, or loaded from a passive stage into a job. Table definitions specify the format of data files and tables and can be imported from sequential files.
DataStage Manager allows users to manage metadata for DataStage jobs. It includes branches for data elements, jobs, routines, shared containers, stage types, table definitions, and transforms. Metadata can be imported from files, created manually in Manager, or loaded from a passive stage into a job. Table definitions specify the format of data files and tables and can be imported from sequential files.
DataStage Manager allows users to manage metadata for DataStage jobs. It includes branches for data elements, jobs, routines, shared containers, stage types, table definitions, and transforms. Metadata can be imported from files, created manually in Manager, or loaded from a passive stage into a job. Table definitions specify the format of data files and tables and can be imported from sequential files.
Download as PPT, PDF, TXT or read online from Scribd
Download as ppt, pdf, or txt
You are on page 1/ 13
Data Stage Manager
Module Objectives
Understand DataStage Manager components and
functionality Manually create metadata Import metadata from a sequential file Load metadata into a passive stage DataStage Manager
Jobs
Branches: Data Elements Jobs Routines Shared Containers Stage Types Table Definitions Transforms Where the Metadata Comes From
Metadata is imported File definitions Table definitions DataStage components Metadata is created Jobs are created in Designer Data elements, routines, table definitions, transforms can be created in Manager Exporting DataStage Components
Objects to export Importing DataStage Components
List objects in file
Import objects in file
Table Definitions
Specify the format of data files and tables
Reusable Use table definitions for: Sequential files ODBC data source tables UniVerse tables Hashed files “Loosely coupled” with the data it defines Can be used for any data with the same format (relational, sequential, hashed) Importing Sequential File Metadata
File directory
Sequential files
Type Data source
Specifying the Format
Column names Delimiter
Preview the data
Specifying the Column Definitions
Modify as needed Manually Creating a Table Definition
