Expression Macros in Informatica Cloud (IICS) Visualpath

1. Expression Macros in Informatica Cloud (IICS) Visualpath Introduction Expression is a passive transformation which allows you to create Output Field and Variable Field types to perform non-aggregate calculations and create new fields in the mapping. Expression transformation also provides two other field types in Informatica Cloud Data Integration which are Input Macro Field and Output Macro Field. A Field expression transforms source data before loading into target. The scope of a field expression you define for an Output or a Variable field is within that field itself. It cannot be extended for other fields. In order to extend the field expression logic to other fields you need to define same logic for each field separately. For example, you need to convert source data into Upper case before loading into target. To implement this, you need to apply the upper conversion logic for each field separately. What are Expression Macros? An Input Macro Field expression represent the data of multiple source fields. An Output Macro Field expression represents the calculations that you want to perform on each input source field. The expression macros can be implemented in 3 different types.  Vertical Macro Horizontal Macro Hybrid Macro For more information Click Here Contact Us: 9989971070  