Records Dropped

G SHIVARANJANI · Post by **G SHIVARANJANI** » Fri Jul 20, 2007 3:39 am

Hi
Why do we get the following warning, when i tried to move data from a table to a squential file.

APT_CombinedOperatorController,0: Field 'LAST_UPDATE_DATE' from input dataset '0' is NULL. Record dropped.

thanks,

balajisr · Post by **balajisr** » Fri Jul 20, 2007 3:48 am

You have not handled null in the field 'LAST_UPDATE_DATE'.

Set APT_DISABLE_COMBINATION environment variable to true to find out in which stage of the job the error occurs. If the stage is a transformer then you have lot of null handling functions available. Refer the manual for null handling functions.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Fri Jul 20, 2007 3:57 am

Hi,

Its working fine when i tried to load this column of the table with summ value.

Please let me know how to use APT_DISABLE_COMBINATION environment variable .

the stage is a transformer but i dint move the column from tthe table to output of transformer. then where do i get the need to use null handling functions .

balajisr wrote:You have not handled null in the field 'LAST_UPDATE_DATE'.

Set APT_DISABLE_COMBINATION environment variable to true to find out in which stage of the job the error occurs. If the stage is a transformer then you have lot of null handling functions available. Refer the manual for null handling functions.

balajisr · Post by **balajisr** » Fri Jul 20, 2007 4:01 am

Are you using the field 'LAST_UPDATE_DATE' in the transformer?

If so, post the derivation in which you had used the above field.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Fri Jul 20, 2007 4:09 am

i am not using. it any where.

i ll change the query.

balajisr wrote:Are you using the field 'LAST_UPDATE_DATE' in the transformer?

If so, post the derivation in which you had used the above field.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Sat Jul 21, 2007 1:10 am

When theres null value in one of the column in a table. when that column value is used any transformer or any other stage.

the row which has null value in a column is being dropped.

please help

vikasjawa · Post by **vikasjawa** » Sat Jul 21, 2007 4:16 am

Hi
Just try setting the nullable property of the cloumn to "Yes".Hope so this would work.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Sat Jul 21, 2007 4:47 am

I have put up that as well

vikasjawa wrote:Hi
Just try setting the nullable property of the cloumn to "Yes".Hope so this would work.

Minhajuddin · Post by **Minhajuddin** » Sat Jul 21, 2007 4:53 am

Can you give us the design of the job, It would make the task of fixing up this warning easier.

But, My guess is that you are using this column --> 'LAST_UPDATE_DATE' somewhere in your constraint or may be you have a column derivation which does not do the null handling or the nullable property set as No in one of the stages.

So, it would be easy to fix your warning if you could paste the exact constraint and the column derivation for this column.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Sat Jul 21, 2007 8:32 am

Hi,

It worked fine when gave the query as:

SELECT

NVL(TO_CHAR(TRUNC(LAST_UPDATE_DATE),'YYYYMMDD'),' ') LAST_UPDATE_DATE

FROM

<<TABLE>>

Minhajuddin wrote:Can you give us the design of the job, It would make the task of fixing up this warning easier.

But, My guess is that you are using this column --> 'LAST_UPDATE_DATE' somewhere in your constraint or may be you have a column derivation which does not do the null handling or the nullable property set as No in one of the stages.

So, it would be easy to fix your warning if you could paste the exact constraint and the column derivation for this column.

Minhajuddin · Post by **Minhajuddin** » Sat Jul 21, 2007 1:32 pm

I don't think that's the right way to do it. Because you are passing a SPACE character (' ') when it is null. This would need you to put a logic which converts the SPACE into a null before it inserts into the target table.

If it's fine for you to have SPACES in your TARGET TABLE instead of NULLS then this thing would work. There are more elegant ways to do the same thing.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Sun Jul 22, 2007 9:14 pm

Hi,

Actually i am moving the data from a table to a text file .so this leads to make it work.

Thankuu..

Minhajuddin wrote:I don't think that's the right way to do it. Because you are passing a SPACE character (' ') when it is null. This would need you to put a logic which converts the SPACE into a null before it inserts into the target table.

If it's fine for you to have SPACES in your TARGET TABLE instead of NULLS then this thing would work. There are more elegant ways to do the same thing.

Zhang Bo · Post by **Zhang Bo** » Sun Jul 22, 2007 9:35 pm

you should change both the input and output nullable to YES,and this warning must be removed

G SHIVARANJANI · Post by **G SHIVARANJANI** » Sun Jul 22, 2007 10:26 pm

Ok
I have done this.

thanku.

Zhang Bo wrote:you should change both the input and output nullable to YES,and this warning must be removed

balajisr · Post by **balajisr** » Sun Jul 22, 2007 10:51 pm

G SHIVARANJANI wrote:When theres null value in one of the column in a table. when that column value is used any transformer or any other stage.

the row which has null value in a column is being dropped.

please help

You mentioned in your previous post that you are not using the column anywhere.

DSXchange

Records Dropped

Records Dropped

do not understand why this problem occurs

Re: do not understand why this problem occurs

Re: do not understand why this problem occurs

Re: Records Dropped

Re: Records Dropped

Re: do not understand why this problem occurs