DSXchange

Hi
how to handle nulls in source level

If yuo are using oracle enterprise stage, you can use NVL fucntion to handle null.

If you are using sequential stage to read ascii file you can handle them at column level . edit the column and provide NULL value and that will be replaced if found any null.

Your question is too broad. What kind of source?

Technically sequential files don't have data types and therefore can't have nulls. But we often pretend that they have data types, and therefore must specify how null is represented. This is typically managed through the Null Field Value property.

Specify your requirement clearly. What type of source it is.

1. Databases have their respective functions to deal with NULL.
2. Sequential file don't have datatype.
3. Transformation functions are there.

Please specify your requirement.