IBM Infosphere Data stage and Quality stage contents

Duration of Training : 2 weekends

Why Radical Technologies

Syllabus

 Introduction about Data stage

 Difference between server jobs and Parallel jobs

 Pipeline parallelism and Partition Parallelism

 Partition Techniques

 Configuration file

 Processing Environment

 Data Stage Client and Server Components

Data stage Designer

 Introduction about Data stage Designer

 Repository

 Palatte

 Types of Links

File Stages

 Sequential file

 Data set

 File set

 Lookup file set

Debugging Stages

 Column Generator

 Head

 Peek

 Row Generator

 Sample

 Tail

Database Stages

 Oracle Enterprise

 ODBC Enterprise

 Dynamic RDBMS

 DB2 or UDB Enterprise

 DB2 Connector

 Dynamic RDBMS

 ODBC connector

Processing Stages

 Aggregator

 Change Apply

 Change Capture

 Compare

 Compress

 Copy

 Decode

 Difference

 Encode

 Expand

 Filter

 Funnel

 Join

 Look up

 Merge

 Modify

 Pivote

 Remove Duplicate

 External Filter

 Sort

 Surrogate Key Generator

 Switch

 Transformer

Restructure Stages

 Column Import

 Column Export

Importing and Exporting Data stage components

 Importing the Jobs

 Exporting the Jobs

 Introduction about Data stage Manager

Containers

 Shared Containers

 Local containers

Job Sequence Stages:

 Job Activity

 Execute Command Activity

 Notification Activity

 Terminator Activity

 Wait for file Activity

 End Loop Activity

 Start loop Activity

 Sequencer

Quality stage rule set files

Rule Set Files

 Classification Table

 Dictionary File

 Pattern Action File

 Reference Tables

 Override Tables

User Define Rule sets Creation process

Investigate Stage

 Character Discrete:

• Investigate Character Discrete with C Mask

• Character Discrete with T Mask

• Character Discrete with X Mask

 Character Concatenate:

 Word Investigate:

• Word Investigate for Full Name

• Word Investigate for Address

• Word Investigate for Area

Standardize Stage

• Standardize Country

• Standardize Domain Preprocessing

• Standardize Name

• Standardize Address

• Standardize Area

 Match Frequency Stage

 Data Rules stage

AVI (Address Verification Interface Stage)

Learn Datastage & Qualitystage – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!

Online Batches Available for the Areas

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad