Tip of the Day

Importing oracle Column Definition:
____________________________

Unexpected Default type conversions can be avoided by importing Oracle table definitions using the “orchdbuilt option” of Data Stage Designer.
It is always best option to import the table definitions to avoid unexpected conversions.

***************

Filter option in Sequential Stage:
___________________________

If you want to filter records, you can achieve it by using 'filter' option in sequential file stage. Filter options accepts any valid UNIX command.

For example, if we need to filter out header and trailer records

“/usr/bin/sed '1d; $d' ” as filter option in sequential file stage.

*********

Join Stage column properties:
************************

Be particularly careful with the nullability properties for input links of any Outer Join. Even if the source data is not nullable, the non-key columns must be defined as nullable in the Join stage input in order to identify unmatched records.

**************

Exponential Values aggregation:

If your source data is coming with exponential values and aggregation needs to be done, Take data type as Double instead of decimal in aggregator stage so that the exponential value is read and the aggregation is done appropriately and correctly.

************