DATA STAGE

Introduction

  • Introduction about Data Stage
  • Difference between Server Jobs and Parallel Jobs
  • Difference between Pipeline Parallelisms
  • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
  • Configuration File
  • Difference between SMP/MPD architecture
  • Data Stage Components (Server components/Client Components)
  • Package Installer

Data Stage Administrator

  • Creating project, Editing project and Deleting project
  • Permissions to user
  • .Apt Config file
  • Environment variable creation, permission

Data stage director

  • Introduction to Data stage Director
  • Job status View
  • View logs
  • Scheduling
  • Batches Creation

Designer

  • Introduction about Designer
  • Repository
  • Palatte
  • Types of Links
  • File Stages
  • Sequential File
  • Data set File
  • Lookup file set
  • Difference between Sequential file/Dataset/File set
  • Database stages
  • Dynamic RDBMS
  • Oracle Enterprise
  • ODBC Enterprise
  • Stored Procedure

Processing stages

  • Change Capture (Caption)
  • Compare stage
  • Difference Stage
  • Aggregate Stage
  • Transformer Stage
  • Surrogate Generator Stage
  • Join Generator Stage
  • Merge Generator Stage
  • Lookup Generator Stage
  • Difference between join/Lookup/Merge
  • Difference between join/Lookup
  • Remove Duplicates
  • Switch
  • Pivot
  • Modify
  • Funnel

Debugging stage

  • Head
  • Tail
  • Pea
  • Row Generator
  • Column Generator
  • Sample
  • Job Parameters

Manager

  • Introduction About Data stage Manager
  • Importing the Job
  • Exporting the Job
  • Importing Table Definition
  • Importing Flat File Definition
  • Routines

Containers

  • Difference between Local Container and Shared Container
  • Local Container
  • Shared Container