Detailed Course Outline
1. Data Quality Issues• Listing the common data quality contaminants• Describing data quality processes2. QualityStage Overview• Describing QualityStage architecture• Describing QualityStage clients and their functions3. Developing with QualityStage• Importing metadata• Building DataStage/QualityStage Jobs• Running jobs• Reviewing results4. Investigate• Building Investigate jobs• Using Character Discrete, Concatenate, and Word Investigations to analyze data fields• Reviewing results5. Standardize• Describing the Standardize stage• Identifying Rule Sets• Building jobs using the Standardize stage• Interpreting standardize results• Investigating unhandled data and patterns6. Match• Building a QualityStage job to identify matching records• Applying multiple Match passes to increase efficiency• Interpreting and improving Match results7. Survive• Building a QualityStage survive job that will consolidate matched records into a single master record8. Two-Source Match• Building a QualityStage job to match data using a reference match