Getting some NULL warnings .

[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,

[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 ''

[kollurianu]

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.

[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.

[kollurianu]

Thanks Arnd .

[priyadarshikunal]

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,

[ArndW]

Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed.

[priyadarshikunal]

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

if not able to get all the properties you can use a copy stage

Thanks and Regards,

[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.

[priyadarshikunal]

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,