Data Quality 10: Developer Specialist

As a one-off project addressing the issues in their data warehouse in batch

As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches

As a real-time process addressing issues as they are introduced

As a batch process to be implemented to run on a monthly basis

Run the addresses into the AV transformation without modification.

Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.

Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.

Remove all punctuation before sending the address to the AV transformation.

Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

Only mappings using non active transformations can be used in DQ for Excel.

All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

On suspect/exception records that fall out of a profile, standardization or matching process in IDQ

On records that could not be matched in a matching mapping

On records that are output from the Consolidation transformation

On records that are output from the Association transformation

Never use First Name as it is not necessary

No standardization of First Name field is necessary

Use the Edit Distance strategy

Create Soundex or NYSIIS value for the First Name and use it in match

The Developer can only review Profiles created by the Analyst but can not create any profiles themselves

The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation.

Comments, Tags and Rules can only be applied to profiles in the Analyst Tool

Only one Tag can be applied to each object in a project.

Not at all - Scorecardlng is a separate process

At the start of the process only to assess current data quality levels

At the start and during regular intervals of the process to measure on-going data quality levels

At the end of the process only to prove the value of the data quality tool

Import accelerators directly to Power Center

Install accelerators directly to PowerCenter

Install accelerators into Developer

Export accelerator mapplets and/or mappings to PowerCenter

Edit Distance

Bigram

Hamming Distance

Jaro Distance

populations

accelerators

dictionaries

mapplets