4.3.2.1.2 Expression

The Expression tab allows users to view how business terms from a Primary Catalog (PBSM) map to business terms in a Mapped Catalog (FSDF) using expressions

1. Navigate to the Expression Mapping screen.
2. Use the search bar to filter terms by name from the Primary Catalog. This helps quickly locate a specific business term. The screen displays the Mapping Table. The main section displays a list of mappings in a table format:
   • Primary Catalog Business Terms (PBSM): Original terms from the primary data source.
   • Mapped Catalog Business Terms (FSDF): Target terms from the mapped data catalog.
   • Expression: Shows a View button to inspect transformation logic.
3. On the Mapping Table, click View to display the View Expression Details pane.
4. On the Expression Details pane, the Expression Name and Expression logic is displayed.

   Note:

   Example:

   • Expression Name: Account Age In Months
   • Expression Logic: TRUNC(MONTHS_BETWEEN([As Of Date], [Value Date]))

     This formula calculates the difference in months between two dates, rounded down to the nearest month.