Transformer Null handling and reject link

[PrasannaLkashmiBurri]

Hi,
I have tried the job regarding transformer null handling like to create a transfomer reject link,right click on on an output link and choose "convert to reject" but i didn't get the colums having null values in the reject link.Can any one tell how to get the colums having null values through reject link.

Thanks,
Prasanna Lakshmi.

[mithun.mg]

Hi,
I have tried the job regarding transformer null handling like to create a transfomer reject link,right click on on an output link and choose "convert to reject" but i didn't get the colums having null values in the reject link.Can any one tell how to get the colums having null values through reject link.

Thanks,
Prasanna Lakshmi.

Hello,

Please check the log in the data stage director ,If the records with NULL are getting dropped or not.If they are getting dropped then take care of NULL Handling in Transformer stage.

[ag_ram]

This could have been best posted in Parallel Forum.

..choose "convert to reject" but i didn't get the colums having null values in the reject link..

I just checked with a Parallel Job with your the scenerio(If i properly understood your need) - Input dataset has null-valued columns, Output dataset has nonnull-valued columns but all Null values come from Input dataset should be sent to Reject dataset.

And I got the null values come from Input sent to Reject dataset.

APT_CombinedOperatorController,0: Field 'Col1' from input dataset '0' is NULL. Record sent to reject dataset.

Can you please elaborate this more, if i did not get properly.

[PrasannaLkashmiBurri]

Hai,
Actually transformer will drop the coloums having null values in the expression derivation.But i should get the coloums having null values when we right click on output link and choose "convert to Reject" option i should get null valued colums through reject link.Is it possible with the option "covert to reject".

Thanks,
Prasanna.

[bkumar103]

the reject link will cater only those records which is not processed by any other link. hence filter the records with proper validation( In this case not null validation) for the liks others than the reject link. Then check if the records flows into reject link.

[ag_ram]

Hai,
Actually transformer will drop the coloums having null values in the expression derivation.But i should get the coloums having null values when we right click on output link and choose "convert to Reject" option i should get null valued colums through reject link.Is it possible with the option "covert to reject".

Handling Null Values in Input Columns:
If you use input columns in an output column expression, be aware that a null value in that input column will cause the row to be dropped or, if a reject link has been defined, rejected.

As per your scenerio, you should get rows which do have null values in any columns, in the Transformer Reject Link.

[prasanna2883]

Hi,

Use a Constraint IsNotNull(Column_name), and apply Null handling function NullToValue() for the columns which are getting dropped and you will be able to retrieve the records in reject link

[ag_ram]

Hi,

Use a Constraint IsNotNull(Column_name), and apply Null handling function NullToValue() for the columns which are getting dropped and you will be able to retrieve the records in reject link

If the Stream Output Link of a Transformer Stage is converted to Reject Link using "Convert to Reject" option, that converted Reject Link does not have any appearance of Column Derivation box in the Transformer Stage, which is but used for capturing the records which are not output by any Stream Output Link and the records which are likely to be dropped.

[ray.wurlod]

Or you could make an Otherwise/Log output link (from the Transformer stage) which will serve the same function but which does allow you to specify the record schema on it.