Informatica Data Quality Developer Specialist Certification

1. For the scenario described, where you want to process 80 records as one batch using Data Quality for Excel, the correct answers are:

• A) Set Maximum Occurrences to unbounded to allow the web service to process multiple records in one batch. This configuration tells the web service that there's no limit to the number of records it can accept at once for processing.

• B) In the DQ for Excel settings, increase the Batch size to 80. This will ensure that DQ for Excel processes each batch containing up to 80 records at a time.

The correct answers are A and B, not just D as initially stated.

2. For the recommendation on how to efficiently extract data from various sources and compare it against master data for each load without delaying the load process, the best approach would be:

• A) Use Identity Match with Persistent RecordID which uses Universal ID. This method allows users to store matching keys to make subsequent matching processes more efficient, which is critical when you need to match large volumes of source data against master data on a regular basis. It's designed for high-performance matching and will significantly improve the performance compared to matching every time without using this feature.

The other options mentioned (B, C, D) have their own use cases but are not as efficient for the scenario described where performance and speed are critical, and you need to compare source data against master data regularly.