Informatica PR000005 Quiz 5 Topic 5 Questions 21-25

Question: 1

Where are IDQ mappings saved?

AIn the location specified in your Source object

BIn the Staging Database

CIn the Model Repository

DOn the Object Explorer tab in the Developer

Show Answer

Question: 2

You want to derive the gender from a firstname, how would you do this?

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

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

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

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

Show Answer

Question: 3

Which strategy pairs characters together as its match algorithm?

AEdit Distance

BBigram

CHamming Distance

DJaro Distance

Show Answer

Question: 4

What types of profiling can be performed in the Developer Tool in Data Quality?

AColumn Profiling, Primary Key Inference, Dependency Inference

BColumn and Join Profiling only

CColumn, Join Analysis, Mid Stream and Comparative Profiling

DColumn, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Show Answer

Question: 5

What Data Quality Transformation utilizes Identity populations?

AKey Generator Transformation

BMatch Transformation

CEdit Distance Transformation

DComparison Transformation

Show Answer

Informatica PR000005 Quiz:5 Topic:5 Questions:21-25