nulls

rameshv · Post by **rameshv** » Sun Feb 21, 2010 10:17 pm

Hi
how to handle nulls in source level

singhald · Post by **singhald** » Sun Feb 21, 2010 10:46 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Feb 21, 2010 10:54 pm

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.

abhijain · Post by **abhijain** » Mon Feb 22, 2010 2:13 am

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.