Data-Quality-10-Developer-Specialist Sample Questions Answers

Import accelerators directly to Power Center

Install accelerators directly to PowerCenter

Install accelerators into Developer

Export accelerator mapplets and/or mappings to PowerCenter

Once added, the target will display resolution for each folder imported.

A conflict resolution can be selected to apply to all imported objects.

Default is replace, options include rename or reuse.

The import can consist of an XML file and a Zip file containing the reference tables

By running the DQ Client installer

The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables

The Analyst populates and creates the table in the Analyst tool

The Administrator needs to create a DQA Service and associate it with the staging database

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

Set parameter for RTM Location/ Path

Set parameter for RTM Name

Ability to parameterise relational and flat-file connections

All of the above

It manages the dictionaries created in the Analyst Tool.

It provides the DIS with information on the location of the address validation data as well as license and other AV configuration settings.

It runs Identity Matching

It makes the Profile repository available to outside reporting applications like Jaspersoft.

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