Once the transformation has been created and the metadata entered, the actual SQL code used by the transformation can be defined. The SQL code can be entered directly or via the Function Builder on the right. To use the Function Builder, expand the tree to find the required function.

Oracle Example of Building a Transformation Model

To build a model TO_DATE, converting a trimmed string in YYYYMMDD format to a date, do the following:

  1. Click the Model tab.
  2. Expand Functions heading.
  3. Expand the Conversion heading.
  4. Double-click To Date (TO_DATE).
  5. Highlight numeric_column.
  6. Expand the String heading.
  7. Double-click Right Trim (RTRIM).
  8. Highlight [format] and type 'YYYYMMDD'.

You should see the following:

Click OK.  

  • No labels