Informatica PR000005 Quiz 6 Topic 7 Questions 26-30

Question: 1

Which of the following is not true when it comes to creating and updating Reference Tables?

AReference Tables can be updated from a Value Frequency list in the Developer

BAll except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

CReference Tables maintained in the Analyst and Developer tools are stored in separate repositories

DReference Tables can be imported and exported using the Developer Tool

Show Answer

Question: 2

What is required for customers to access and use IDQ Accelerator content?

ACustomers must license each Accelerator pack individually to download and use the content.

BNo additional steps are required. All Accelerator content is provided with the basic IDQ license.

CIDQ customers simply need to request an IPS resource to download and install the content.

DAccelerator content is available only with a PowerCenter license.

Show Answer

Question: 3

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: 4

What Data Quality Transformation utilizes Identity populations?

AKey Generator Transformation

BMatch Transformation

CEdit Distance Transformation

DComparison Transformation

Show Answer

Question: 5

Where does Scorecarding fit into the data quality process?

ANot at all - Scorecardlng is a separate process

BAt the start of the process only to assess current data quality levels

CAt the start and during regular intervals of the process to measure on-going data quality levels

DAt the end of the process only to prove the value of the data quality tool

Show Answer

Informatica PR000005 Quiz:6 Topic:7 Questions:26-30