The IBM InfoSphere QualityStage - Essentials training course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. You will gain experience by building an application that combines customer data from three source systems into a single master customer record.
The IBM InfoSphere QualityStage - Advanced training course will step you through the QualityStage data cleansing process. You will transform an unstructured data source into a format suitable for loading into an existing data target. You will cleanse the source data by building a customer rule set that you create and use to standardize the data. You will next build a reference match to relate the cleansed source data to the existing target data.
In IBM InfoSphere QualityStage - Postal Modules training course, you will learn to build QualityStage jobs that standardize and verify address data. Gain hands-on experience building jobs that use MNS, CASS, WAVES, and AVI stages. Use the AVI stage to standardize multibyte-encoded address data.
By attending IBM InfoSphere QualityStage - Essentials workshop, delegates will learn to:
- List the common data quality contaminants
- Describe each of the following processes:
- Investigation
- Standardization
- Match
- Survivorship
- Describe QualityStage architecture
- Describe QualityStage clients and their functions
- Import metadata
- Build and run DataStage/QualityStage jobs, review results
- Build Investigate jobs
- Use Character Discrete, Concatenate, and Word Investigations to analyze data fields
- Describe the Standardize stage
- Identify Rule Sets
- Build jobs using the Standardize stage
- Interpret standardization results
- Investigate unhandled data and patterns
- Build a QualityStage job to identify matching records
- Apply multiple Match passes to increase efficiency
- Interpret and improve match results
- Build a QualityStage Survive job that will consolidate matched records into a single master record
- Build a single job to match data using a Two-Source match
By attending IBM InfoSphere QualityStage - Advanced workshop, delegates will learn to:
- Modify rule sets
- Build a custom rule set
- Build QualityStage jobs to investigate data quality issues with newly standardized file
- Match related product and data warehouse records using QualityStage reference matching
By attending IBM InfoSphere QualityStage - Postal Modules workshop, delegates will learn to:
- Standardize multinational address data including multibyte character data
- Validate standardized addresses
For IBM InfoSphere QualityStage - Essentials
- Have Knowledge of:
- Windows
- A text editor
For IBM InfoSphere QualityStage - Advanced
- Attend IBM InfoSphere QualityStage - Essentials training course or have equivalent experience
- Have familiarity with:
- Windows
- A text editor
For IBM InfoSphere QualityStage - Postal Modules
- Familiarity with Windows
- Fundamental knowledge of QualityStage
The IBM InfoSphere QualityStage - Essentials classs is ideal for Data Analysts, Quality Architects and Data Cleansing Developers.
The IBM InfoSphere QualityStage - Advanced class is recommended for:
- Data Analysts responsible for data quality using QualityStage
- Data Quality Architects
- Data Cleansing Developers
- Data Quality Developers needing to customize QualityStage rule sets
The IBM InfoSphere QualityStage - Postal Modules class is recommended for:
- Data Analysts
- Data Quality Architects
- Data Cleansing Developers
- Data Quality Developers needing to standardize and validate address data