Informatica PR000005 Quiz 3 Topic 7 Questions 11-15

Question: 1

When using field matching which is the best approach if using First Name as a match field?

ANever use First Name as it is not necessary

BNo standardization of First Name field is necessary

CUse the Edit Distance strategy

DCreate Soundex or NYSIIS value for the First Name and use it in match

Show Answer

Question: 2

With respect to field matching in IDQ, which best describes the approach to address matching?

ANo standardization is necessary, map input fields to the match transformation

BStandardize address fields and use address line, locality, region and postcode fields as input to the match transformation

CStandardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

DStandardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Show Answer

Question: 3

Which statements describe the Consolidation Transformation?Choose 2 answers

Aa passive transformation

Ban active transformation

Ca transformation which is found only in PowerCenter

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

Show Answer

Question: 4

What happens to the records when corrections are made and a status of Accept is assigned?

AThe corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

BThe corrections are committed to the Staging DB and record is automatically pushed into another DB

CRecords are corrected and are sent to an Accepted DB table

DRecords are accepted and are pushed out to Target/Production DB

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:3 Topic:7 Questions:11-15