Informatica – PowerCenter – Expressions

Expressions can be entered using expression editor in following transformations :
  • Aggregator
  • Data masking
  • Expression
  • Filter
  • Rank
  • Router
  • Update strategy
  • Transaction control
Expressions can be created by following functions:
  • Transformation language functions : SQL like functions
  • User-defined functions : functions created by user based on transformation language functions
  • Custom functions : created with custom function API
Expression editor:
  • Max number of characters 32767
  • Comments can be added as — or //
  • Can not run the session against a mapping with invalid expression
  • Only for data mask trasformation expressions can be given in input ports also ,for all other transformations only in output ports.
  • If expressions are changing frequently,parameters can be used with IsExprVar option as TRUE instead of expressions.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s