Informatica – PowerCenter – Active transformations

Functionality:

  • Change the number of rows
  • Change the transaction boundary
  • Change the row type
Rules :
  • Doesn’t allow to connect multiple active transformations/an active and passive to the same downstream transformation/transformation input group.because the integration service may not be able to concatenate the rows passed by active transformation.
  • Sequence generator is exceptional to this rule
Transformations:
  • Aggregator
  • Application source qualifier
  • Custom
  • Filter
  • Java
  • Joiner
  • Look up
  • Normalizer
  • Rank
  • Router
  • Sorter
  • Source qualifier
  • SQL
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s