DATAWARE Housing Banner

DATA STAGE

		 		 
		  Introduction to Data Stage?
What Is the Meta Data and Structure of Meta Data and Repository?
Data Stage Enterprise Edition
•	Data Stage Client Software
•	Data Stage Server Software
•	Data Stage Client Components
•	Data Stage Server Components
What is the Job and Data flow of Job and Types of Jobs?
•	Server Jobs
•	Client Jobs
•	Mainframe Jobs
What is Difference between Server Job and Parallel Job?
What is Stage and Types of stages?
•	Built – in Stage
•	Positive Stage
•	Database Stages
•	File Stages 
•	Active Stages
•	Processing Stages
•	Plugging Stages
Data Stage Project
•	Built in Components
•	Customized Components
Data Properties
•	Table Def
•	Data Elements
•	Transforms
NLS (National Language Support)
•	Creation of Project
•	Creation of Table Def
Designing Simple Pass Job
Defining the Source Stage
Defining the Target Stage
Defining the transfer Stage
Running the Job
Design Job with Filter Job
Defining the Processing Stage
Join Stage & Sort Stage
What is Aggregator and how to define Aggregate Stage?
What is Funnel Stage and types of Funnel Stages?
•	Continuous Funnel 
•	Sort Funnel
•	Sequence Funnel


What is Surrogate Key and how to generate surrogate key
How to remove duplicates in Remove Stage
Incremental Loading
•	Change Capture Stage
•	Modify Stage
What is switch Stage and how to Generate Switch Stage
What is Lookup Stage and how to Generate Lookup stage
What is Merge Stage and how to Generate Merge Stage
How to Generate Pivot Stage
What is File Systems and types of File systems
•	Sequential File
•	Lookup File Set
•	File Set
•	Data Set
Design Job with following Stages
•	Sequential File Stage
•	Dynamic RDBMS
•	Transformer Stage

Design job with target as Dataset
Design job with source as Dataset
Development & Debugging Stages
•	Sample
•	Head
•	Tail
•	Row – Generate
•	Column Generate
Meta Data Backup & Recovery
Schedule the Job
Add to Schedule
How to Create Batch and Job Parameters
How to define Target Stage and Transformer Stage
Data Stage – SQL Override
Define a Job with SQL Override – Filter
•	Join
•	Sorter
What is Container and types of Containers?
•	Local Container
•	Shared Container
•	De-Contraction of container
What is Job Sequence how to use the Job Sequence?
What is Server jobs and how to use server jobs?
Creation of ODBC DSN