Multiple choice technology

Which of the following is true about the Union transformation?

  1. Multiple input and output groups can be created.

  2. All the input groups and output groups should not have matching ports.

  3. The union transformation does not generate any transactions.

  4. The precision, data type and scale does not necessarily be same across all the groups.

  5. None of these.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Union transformation in Informatica is a passive transformation that merges data from multiple pipelines. It does not generate transaction boundaries (commit points) - it simply unions the data. Option A is incorrect because Union has multiple input groups but only one output group. Option B is incorrect because matching ports are required across input groups. Option D is incorrect because precision, datatype, and scale must match across groups for union compatibility.

Keep practicing — related questions