Getting some NULL warnings .
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Getting some NULL warnings .
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,
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,
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 ''
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 ''
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
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.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 ''
Any inputs greatly appreciated.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Transform will reduce the efficiencyArndW 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. ...
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,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
thats why i suggested to use a copy stage.ArndW wrote:Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed. ...
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,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI