Field 'Emp_code' from input dataset '0' is NULL. Record drop

singhald · Post by **singhald** » Fri Nov 14, 2008 3:35 am

Hi All,

I have use the dsxchange search, i found so many way to deal with this situation, but not able to resolve my issue.

I am getting the below warning messages in DS log.

Xfm_Validation,0: Field 'Emp_code' from input dataset '0' is NULL. Record dropped.

I am reading the field 'Emp_code' [Varchar2(1) NULL ] from oracle table using oracle enterprise stage. my traget is sequential file with same metadata 'Emp_code' [Varchar2(1) NULL]

I have handled the null while writing into sequentail stage. there i used Null field value = ''.

But still I am getting the same warning message.

Thanks

mdbatra · Post by **mdbatra** » Fri Nov 14, 2008 3:51 am

Have to do this setting both sides, i.e Source(Oracle Stage) & target(File)

prasanna2883 · Post by **prasanna2883** » Fri Nov 14, 2008 3:54 am

Try to use NullToEmpty(EMP_CODE) in the column derivation, and let me know if the problem still exist

singhald · Post by **singhald** » Fri Nov 14, 2008 4:02 am

hello MDBatra,

can you please tell how to do this setting source side.

i didn't find any option to set in source side.

Thanks

Deepak[/quote]

singhald · Post by **singhald** » Fri Nov 14, 2008 4:06 am

prasanna i have also used the nulll to empty in target field derivation, but it didn't work.

Thanks

prasanna2883 · Post by **prasanna2883** » Fri Nov 14, 2008 4:28 am

It should work but r u recieving the same message? In the source query try to use NVL(EMP_CODE,'') as EMP_CODE.

Is that a direct mapping or do u have any intermediate stages between source and target.

In which stage u r recieving this 'Field 'Emp_code' from input dataset '0' is NULL. Record drop' mesage?

If this doesn't work try to NULLFIELDVALUE property in target sequential file as 0

singhald · Post by **singhald** » Fri Nov 14, 2008 4:37 am

i am getting this message in transformer stage, i am not using any intermediate stages. or derivation.

i have one question. if a source filed is null and direct mapped to target field witout any trasformaiton, why we need to do any null handling.\

Thanks

consulting · Post by **consulting** » Fri Nov 14, 2008 4:41 am

Handle isnull(columnname) and do the process asper your reqirment
handle isnull in all the place like stae variable and transformer

Romy · Post by **Romy** » Fri Nov 14, 2008 4:43 am

The target column for that source column may be non nullable... hence if you try to insert with the null values it wont accept. you need to convert it into a varchar "". In transformer you can add the express ion to that column as if source_file.column_a=@null then '' else source_file.column_a

mdbatra · Post by **mdbatra** » Fri Nov 14, 2008 4:47 am

U need to Double click on the Row no in the Column Tab of Source Stage.
& There u can see the null handling setting.

singhald · Post by **singhald** » Fri Nov 14, 2008 4:55 am

my source is oracle table , in oracle stage you cant change any setting for a field

prasanna2883 · Post by **prasanna2883** » Fri Nov 14, 2008 5:17 am

But u can modify the oracle source query for null handling.

mdbatra · Post by **mdbatra** » Fri Nov 14, 2008 5:17 am

job design plz..!

rajngt · Post by **rajngt** » Fri Nov 14, 2008 6:12 am

Null field value = ''

change this to Null field value = ' ' (space), try the run now. as you are providing earlier you have provide null value