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.
Transformer Null handling and reject link
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Mon May 26, 2008 7:23 am
Transformer Null handling and reject link
Prasanna Lakshmi
Re: Transformer Null handling and reject link
PrasannaLkashmiBurri wrote: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.
Thanks & Regards
MITHUN M G
ETL Devloper
MITHUN M G
ETL Devloper
This could have been best posted in Parallel Forum.
And I got the null values come from Input sent to Reject dataset.
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...choose "convert to reject" but i didn't get the colums having null values in the reject link..
And I got the null values come from Input sent to Reject dataset.
Can you please elaborate this more, if i did not get properly.Job Log wrote:APT_CombinedOperatorController,0: Field 'Col1' from input dataset '0' is NULL. Record sent to reject dataset.
-
- Participant
- Posts: 5
- Joined: Mon May 26, 2008 7:23 am
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.
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.
Prasanna Lakshmi
PrasannaLkashmiBurri wrote: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".
As per your scenerio, you should get rows which do have null values in any columns, in the Transformer Reject Link.Parallel Job Developer's Guide in Page# 448 wrote: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.
Last edited by ag_ram on Tue May 27, 2008 5:10 am, edited 1 time in total.
-
- Participant
- Posts: 26
- Joined: Tue Oct 23, 2007 4:07 am
- Location: Blore,India
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.prasanna2883 wrote: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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.