Data-Quality-10-Developer-Specialist Data Quality 10: Developer Specialist Exam Questions and Answers

a passive transformation

an active transformation

a transformation which is found only in PowerCenter

creates a single, consolidated record from records identified as possible duplicates by the Match transformation

The Advanced method allows conflict resolution and the Basic doesn't.

The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.

Import steps can be undone in the Advanced Wizard but not in the Basic one

Users have a choice regarding which project objects are imported using Basic and Advanced.

Expression Transformation

Address Validation Transformation

Aggregator Transformation

Labeler Transformation

Token Parser

Standardizer

Exception

Labeler

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.

The same icon is used to indicate a shared and non shared project.

Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

Allow the wizard in Developer to automatically select the data types when creating the data objects.

Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.

Import the file into a database table before profiling.

Change the code page of the file to UTF-8.