Warning at Source

[bbobpop1]

Hi

My job is designed below:

Source (ODBC) --- LOOKUP --- TRASFORMAER -- FLATFILE (FIXED WIDTH).

Warning :
When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result;

I am using a view as a source.

1) If I make the field "XXXX" as Nullable Y, Then I will give me the warning at the Lookup Stage. At Lookup This field is not null.
2) If I make it NULL at lookup then it aborts the job. Because it is output from the lookup.
3) As target is SEQ file, XXXX field should be NULLABLE "NO"
4) I tried using CAST and NVL functions in the QUERY as well.

Can you please help me to remove this warning?

Thanks
Bob

[ray.wurlod]

If your Lookup Failed rule is "Continue" then all fields on the reference input need to be nullable, as do any output fields derived from them. With "Continue" you are effectively doing a left outer join, with the reference input the right hand side of that join.

[bbobpop1]

Hi Ray,

Thanks for the reply. The resolution that you have provided is working fine.
However I didn't understand if I define a field say "XXXX" as a KEY then how datastage allows us to make it NULLABLE. Because as per my understanding (Consider Primary Key) key should not containt null.

Can you please let me know how DS handles this concept?

[ray.wurlod]

Your understanding that "Key" = "consider to be primary key" is the flaw. In this context "Key" means "join key", or common value used to identify the join. Neither in DataStage nor in SQL does the join key have to be a primary key.

[bbobpop1]

Thanks ray. I was thinking in different way.... :D