Null handling

ketanshah123 · Post by **ketanshah123** » Wed Jun 25, 2008 11:54 pm

Hi

How to handle nulls in sequential file?
How to handle any other invalid data in Sequential file?
How to handle nulls in date in transformer?

Thanx in advance

ray.wurlod · Post by **ray.wurlod** » Thu Jun 26, 2008 12:38 am

1. Specify how null is (or is to be) represented in the sequential file. If the format is fixed width, the null field value must have the same number of characters as the field's width.

2. Data that do not match the record schema can be captured on a reject link, or the row simply dropped, or the job aborted. This is configured through the Reject Mode property.

3. Make sure no function receives a null argument. Make sure that any column marked as "not nullable" does not receive a null value. Intercept null as early as possible (stage variables?) and convert to a known other value.

DSRajesh · Post by **DSRajesh** » Thu Jul 03, 2008 3:33 am

Hi

You can handle null values for Date field in Transformer as:

Check first of all the null values exist with that field or not using ISNULL() then replace that value with some value what you want represent as like RAY said in stage variable and use that in the derivative Field of that column.