Free Practice Questions for Informatica Data-Quality-10-Developer-Specialist Exam

Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Expression Transformation

Address Validation Transformation

Aggregator Transformation

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

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

Rules

Reference tables

Demonstration mappings

Demonstration data objects

Profiles

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.

Only if the customer thinks it's a good idea

Only if the quality of the data is poor

Not always. If the dataset is small enough, grouping is not required

Yes, it's always necessary

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.

Locality / City

ElementlnputStatus

Match Code

MSA