Search code examples
informaticainformatica-powercenterinformatica-cloud

Concatenation disallowed on transformation CLM_DATA. Active transformation(RTR.T_GRP,RTR.B_GRP)

I am trying to link my Expression to Target table but i'm having the error message.Concatenation disallowed on transformation CLM_DATA. Active transformation(RTR.T_GRP,RTR.B_GRP) screenshot of my RTR and EXP

Solution

  • There seems to be an Active transformation on parallel pipeline. Active transformation is one that may change the order or number of rows. In such case you can't bring both pipelines to one transformation - a joiner needs to be used.