Informatica Data Quality

1.

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

PC 8.6.1 and higher PC 8.51 and higher All PC versions PC 8.11, PC 8.51 and PC 8.6

2.

During a project export, typically what will the output be from the export?

An xml file containing all the mapping/mapplet/object definition An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required The contents of each Project (including the dependent reference tables) in a zip file Projects will be exported to an .irob file

3.

Which Informatica option provides solutions to common data quality issues in a country, region,or industry?

populations accelerators dictionaries mapplets

4.

Which of these statements is true about Data Rules?

Data Rules must be run against the entire data set they are defined upon Once created a Data Rule cannot be changed...it can only be deleted and re-created A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer Data Rules can only be run on data in the project in which they were created

5.

The IDQ and PowerCenter repositories all share the same schema.

1

6.

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Number of Columns in the file Number of Rows in the source data Amount of memory and speed of the processor on the server All of the above

7.

You have just standardized values in a field and you would like to review how the modified dataappears alongside the original data. Which profiling method would best be suited for this?

Column Profiling Mid Stream Profiling Join Analysis Profile Comparative Profiling

8.

What functionality does Data Quality Assistant provide? Choose 2 answers

Consolidate duplicates into master record Bad record management Automatically consolidates data ReGroup records for matching

9.

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

The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record The corrections are committed to the Staging DB and record is automatically pushed into another DB Records are corrected and are sent to an Accepted DB table Records are accepted and are pushed out to Target/Production DB

10.

Where does Scorecarding fit into the data quality process?

Not at all - Scorecardlng is a separate process At the start of the process only to assess current data quality levels At the start and during regular intervals of the process to measure on-going data quality levels At the end of the process only to prove the value of the data quality tool

Informatica Data Quality

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Informatica Data Quality

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner