Page 1 of 1
records dropped in transformer
Posted: Wed Jun 21, 2006 12:04 pm
by mab_arif16
Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.
I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif
Re: records dropped in transformer
Posted: Wed Jun 21, 2006 12:46 pm
by kris007
mab_arif16 wrote:Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.
I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif
Make sure you perform ISNULL check on COL1 in all the references.
Posted: Wed Jun 21, 2006 1:09 pm
by pavankvk
I had a similar problem.
i used another transformer to check IsNull(column) Then set 'X' and in the actual transformer i checked for value of 'X'.
Re: records dropped in transformer
Posted: Wed Jun 21, 2006 1:10 pm
by mab_arif16
kris007 wrote:mab_arif16 wrote:Hi
In one of my job , a transformer which checks the following null condition
if ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) then RM_NULLS.COL3= RM_NULLS.COL4 else RM_NULLS.COL3
for which I am getting warning
APT_CombinedOperatorController,0: Field 'COL1' from input dataset '0' is NULL. Record dropped.
I tried giving a reject link ,but it didnt work ,is there some way to get rid of this warning.
Thanks
Arif
Make sure you perform ISNULL check on COL1 in all the references.
Thats the only palce where I am referencing column 1.
Thanks
Arif
Posted: Wed Jun 21, 2006 2:51 pm
by kris007
Are you getting this error message in Transformer stage or in the input dataset stage?If input dataset make sure you are handling nulls for that column.
Posted: Fri Jun 23, 2006 7:47 am
by kumar_s
Is your COL1 column marked as NotNull?
If so handle null for that column.
Also try turning Combinabiltiy to false and rerun the job.
Posted: Tue Sep 12, 2006 10:47 am
by ukyrvd
I had similar problem. In my case, the isnull check and the transformation logic is in StageVariable derivation. If I move that to output column derivation, DS is happy!!
Posted: Tue Sep 12, 2006 4:08 pm
by ray.wurlod
You don't do assignment in expressions. The original expression should be
Code: Select all
If ISNULL(RM_NULLS.COL1) And IsNotNull(RM_NULLS.COL2) Then RM_NULLS.COL4 Else RM_NULLS.COL3