What are the restrictions of Union Transformation?

  • All input groups and the output group must have matching ports. The precision, datatype, and scale must be identical across all groups.
  • We can create multiple input groups, but only one default output group.
  • The Union transformation does not remove duplicate rows.
  • We cannot use a Sequence Generator or Update Strategy transformation upstream from a Union transformation.
  • The Union transformation does not generate transactions.

No comments:

Post a Comment