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.

1 comment:

  1. Tejuteju6 June 2018 at 03:08

    Really Good blog post.provided a helpful information.I hope that you will post more updates like this Informatica Online Training Bangalore

    ReplyDelete

Subscribe to: Post Comments (Atom)