Page 1 of 1
Getting some NULL warnings .
Posted: Fri Feb 08, 2008 3:50 pm
by kollurianu
Hi All ,
We are getting some NULL warnings while writing to a reject link from an oracle enterprise stage to a sequential file.How to handle this.
Please advice.
OraRejUpd: When checking operator: When validating export schema: At field "WLESSINTCON_INDX": Exporting nullable field without null handling properties
Any help would be greatly appreciated.
Thank you,
Posted: Fri Feb 08, 2008 4:45 pm
by dspxlearn
kollurianu,
How is the Nullability of 'WLESSINTCON_INDX' from the source and target defined?
If it is Nullable from the source and you if you are explicitly making it to NotNullable, they you should be doing the Null check.
If IsNotNull(WLESSINTCON_INDX) then WLESSINTCON_INDX else ''
Posted: Sat Feb 09, 2008 6:47 am
by kollurianu
dspxlearn wrote:kollurianu,
How is the Nullability of 'WLESSINTCON_INDX' from the source and target defined?
If it is Nullable from the source and you if you are explicitly making it to NotNullable, they you should be doing the Null check.
If IsNotNull(WLESSINTCON_INDX) then WLESSINTCON_INDX else ''
The source field is null then and target sequential stage (the reject link) is greyed out in , but the rejec records are giving the above error.
Any inputs greatly appreciated.
Posted: Sat Feb 09, 2008 7:54 am
by ArndW
Put a Transform or Modify stage at the end of the output reject link so you can change the column metadata and values as described by dspxlearn.
Posted: Sun Feb 10, 2008 4:12 pm
by kollurianu
Thanks Arnd .
Posted: Mon Feb 11, 2008 2:06 am
by priyadarshikunal
ArndW wrote:Put a Transform or Modify stage at the end of the output reject link so you can change the column metadata and values as described by dspxlearn. ...
Transform will reduce the efficiency
double click on the row number to get all the properties exposed
there put the null handling details
like null field value etc
if not able to get all the properties you can use a copy stage
this will use implicit modification without warning
regards,
Posted: Mon Feb 11, 2008 2:43 am
by ArndW
Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed.
Posted: Mon Feb 11, 2008 3:37 am
by priyadarshikunal
ArndW wrote:Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed. ...
thats why i suggested to use a copy stage.
i know i haven't written it precisely
but i have suggested to use a copy stage
i think using a copy stage is better than using modify or
transformer
Priyadarshi wrote:if not able to get all the properties you can use a copy stage
Thanks and Regards,
Posted: Mon Feb 11, 2008 3:53 am
by ArndW
I think the best stage to use is Modify, since this is precisely what it was designed for. Although a copy stage can do it, I prefer not to use it - but that is more a matter of personal taste than anything else.
Posted: Mon Feb 11, 2008 6:27 am
by priyadarshikunal
ArndW wrote: but that is more a matter of personal taste than anything else.
Thats true
any ways i will try both ideas
yours as well as mine
let's see which takes least time
Thanks and Regards,