Informatica Data Quality Set 1

Scorecarding ✘ Matching ✘ Grading ✘ Standardization ✔

Column Profiling, Primary Key Inference, Dependency Inference ✘ Column and Join Profiling only ✘ Column, Join Analysis, Mid Stream and Comparative Profiling ✘ Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling ✔

Decision ✘ Standardizer ✘ Comparison ✘ Parser ✔

DQ for Excel allows .xls files be used as source and target objects in mappings ✘ DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/
Worksheets. ✘ DQ for Excel can be used in any version of Excel. ✘ In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed. ✔

Using the IDQ content installer ✘ It is imported through Developer ✘ The file extracted onto the server and it is automatically picked up after restarting the services ✘ It is installed using the importer available in the Content Management service ✔

The order of the reference tables defined will not impact your results displayed ✘ Selecting Inclusive mode will output items that are present in the reference table under the label provided ✘ Selecting Exclusive mode will exclude Items that are present in the reference table ✘ Any items that do not appear in the reference table are not displayed in the output ✔

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. ✔

There is no specific reason. It is simply a step of an ordered best practice approach. ✘ It is good because it is easier to determine if a field is numeric or text. ✘ Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify. ✘ None of the above ✔

Token Parser ✘ Standardizer ✘ Exception ✘ Labeler ✔

Reference Tables can be updated from a Value Frequency list in the Developer ✘ All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst ✘ Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories ✘ Reference Tables can be imported and exported using the Developer Tool ✔