Table of Contents


  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Access Policy transformation
  6. Aggregator transformation
  7. Cleanse transformation
  8. Data Masking transformation
  9. Data Services transformation
  10. Deduplicate transformation
  11. Expression transformation
  12. Filter transformation
  13. Hierarchy Builder transformation
  14. Hierarchy Parser transformation
  15. Hierarchy Processor transformation
  16. Input transformation
  17. Java transformation
  18. Java transformation API reference
  19. Joiner transformation
  20. Labeler transformation
  21. Lookup transformation
  22. Machine Learning transformation
  23. Mapplet transformation
  24. Normalizer transformation
  25. Output transformation
  26. Parse transformation
  27. Python transformation
  28. Rank transformation
  29. Router transformation
  30. Rule Specification transformation
  31. Sequence Generator transformation
  32. Sorter transformation
  33. SQL transformation
  34. Structure Parser transformation
  35. Transaction Control transformation
  36. Union transformation
  37. Velocity transformation
  38. Verifier transformation
  39. Web Services transformation



Hybrid macros

Hybrid macros

A hybrid macro expands an expression both vertically and horizontally. A hybrid macro generates a set of vertical expressions that also expand horizontally.
Configure a hybrid macro based on your business requirements. Use the configuration guidelines for vertical and horizontal macros to create a hybrid macro.


For example, the following expression uses the %OPR_IIF% horizontal expansion function to convert the format of the date fields represented by the %dateports% macro input field to the 'mm-dd-yyyy' format:
The %fromdateformat% macro input field defines the different date formats used in the date fields: mm/dd/yy and mm/dd/yyyy.
At run time, the application expands the expression vertically and horizontally, as follows:
IIF(IS_DATE(StartDate,’mm/dd/yy’),TO_STRING(TO_DATE(StartDate,’mm/dd/yy’),’mm-dd-yyyy’), IIF(IS_DATE(StartDate,’mm/dd/yyyy’),TO_STRING(TO_DATE(StartDate,’mm/dd/yyyy’),’mm-dd-yyyy’), StartDate)) IIF(IS_DATE(EndDate,’mm/dd/yy’),TO_STRING(To_Date(EndDate,’mm/dd/yy’),’mm-dd-yyyy’), IIF(IS_DATE(END _DT,’mm/dd/yyyy’),TO_STRING(TO_DATE(EndDate,’mm/dd/yyyy’),’mm-dd-yyyy’), EndDate))
The expression expands vertically to create an expression for the StartDate and EndDate fields that %dateports% represents. The expression also expands horizontally to use the constants that %fromdateformat% represents to evaluate the incoming fields.


We’d like to hear from you!
Patrick Dwyer - June 05, 2023

The example shows the "IsDate" function. This should be corrected to "Is_Date" function.

Informatica Documentation Team - June 05, 2023

Hi Patrick Dwyer,

You are correct. Thanks so much for bringing this to our attention! We'll fix it in the next major release.