ICC Testing & Quality Assurance 2 — Questions and Answers
Question 1: Which Informatica IDMC feature allows you to validate a mapping's logic without actually running data through it?
- Data Preview
- Dry Run
- Mass Ingestion Validate
- Mapping Validate (Correct answer)
Correct answer: Mapping Validate
Mapping Validate checks the mapping configuration for errors before execution without processing real data.
Question 2: When testing a Synchronization task in IDMC, what is the recommended approach to limit the rows processed during a test run?
- Set a Row Limit in the task's advanced properties (Correct answer)
- Delete rows from the source before testing
- Use a Filter transformation to restrict data
- Disable all field mappings except one
Correct answer: Set a Row Limit in the task's advanced properties
The Row Limit setting in advanced properties caps the number of records processed, making test runs faster and safer.
Question 3: In IDMC, which log type provides the most granular detail for diagnosing a failed Data Integration task?
- Audit Log
- Session Log (Correct answer)
- Monitor Log
- Error Log
Correct answer: Session Log
The Session Log records row-level processing details, transformation output, and error messages for each task run.
Question 4: A developer wants to test only the target write behavior of a mapping without reading from the real source system. What technique achieves this?
- Replace the source with a Parameter file
- Use a mock source object pointing to a flat file with sample data (Correct answer)
- Enable Verbose tracing on the target
- Disable the source qualifier
Correct answer: Use a mock source object pointing to a flat file with sample data
Swapping the live source for a flat file containing representative sample data isolates target write logic from source connectivity.
Question 5: Which IDMC Taskflow feature helps QA teams ensure that a pipeline only proceeds to the next step when all prerequisite tasks succeed?
- Conditional branching with fault paths
- Success/Failure event-based sequencing (Correct answer)
- Parallel task groups
- Data Quality transformations
Correct answer: Success/Failure event-based sequencing
Event-based sequencing connects tasks using Success or Failure events so downstream tasks only run when upstream tasks complete successfully.
Question 6: In Informatica Data Quality (IDQ) within IDMC, what is the primary purpose of a scorecard?
- To schedule data profiling jobs automatically
- To aggregate rule conformance metrics across datasets over time (Correct answer)
- To generate test data for quality validation
- To map source columns to target columns
Correct answer: To aggregate rule conformance metrics across datasets over time
Scorecards consolidate data quality rule results into trend metrics so teams can track conformance over time.
Question 7: Which best practice should a QA engineer follow when promoting an IDMC mapping from a Development org to a Production org?
- Export the mapping as XML and manually edit environment-specific values
- Use IDMC's built-in Export/Import with environment-specific connection parameters overridden (Correct answer)
- Recreate the mapping manually in the Production org
- Copy the mapping via the IDMC REST API using hardcoded credentials
Correct answer: Use IDMC's built-in Export/Import with environment-specific connection parameters overridden
IDMC's Export/Import process packages the mapping and allows connection overrides so environment-specific settings are applied during import.
ICC Testing & Quality Assurance 2
Which Informatica IDMC feature allows you to validate a mapping's logic without actually running data through it?