Using Format Conversions
If you map to a Table instance Column or a constant with a different data type or format than the Table Descriptor's Column, you can enter a format conversion string for Oracle LSH to convert the value that is upstream in the data flow to the correct format for the downstream value.
For example, if a source Table instance contains a number value that needs to be converted to a dollar amount for the Program to analyze, enter a format conversion such as: format=$99,999.00
. If a source Column has a data value of 10000, Oracle LSH converts that value to $10,000.00.
For format models, see the Oracle 9i SQL Reference Guide.
Parent topic: Mapping Columns Manually