INFORMATICA Data Quality 9.x Developer Specialist 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 ✔

TRUE ✘ FALSE ✘

Decision ✘ Standardizer ✘ Comparison ✘ Parser ✔

Rules Reference tables Demonstration mappings Demonstration data objects Profiles

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