ICC Testing & Quality Assurance 3

Question 1

During unit testing of an IDMC mapping, a tester discovers that a Lookup transformation returns incorrect results for null keys. What is the best corrective action?

Accepted Answer

Configure null handling in the Lookup condition or add a default value expression

Answer

Configuring null handling in the Lookup condition or providing default values explicitly prevents unexpected behavior when keys are null.

Question 2

What does the 'Commit Interval' setting control in the context of testing IDMC target writes?

Accepted Answer

The number of rows written before the target is committed as a transaction batch

Answer

Commit Interval defines the batch size of rows written before a database commit is issued, affecting transaction granularity and rollback behavior during testing.

Question 3

A QA team needs to verify that an IDMC integration correctly rejects records that violate a NOT NULL constraint on the target. Which approach best tests this scenario?

Accepted Answer

Inject test records with null values in the required field and confirm rejection in the session log

Answer

Injecting known-null records lets testers confirm the mapping correctly handles constraint violations and logs rejected rows.

Question 4

In IDMC Application Integration, what is the purpose of a Service Connector's test connection feature?

Accepted Answer

To verify that the configured endpoint URL and credentials are reachable before runtime

Answer

Test connection validates the endpoint URL, authentication credentials, and network reachability without executing any integration logic.

Question 5

Which IDMC feature provides the ability to compare source and target row counts automatically as part of post-load validation?

Accepted Answer

Data Validation Option (DVO)

Answer

The Data Validation Option runs automated source-to-target reconciliation checks including row count comparison after a task completes.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Testing & Quality Assurance 3