Join_Null Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gopinath
Participant
Posts: 52
Joined: Wed Apr 25, 2007 2:18 am
Location: Chennai

Join_Null Error

Post by Gopinath »

Hi,

I need a Quick turn around from u guys..
My Issue is like, Iam using a Join stage (Left Outer),
Iam just capturing the matching records into the dataset.
Iam getting the required amount columns exactly.

But, i need to check for nullability for these amount columns, so i have used transformr after the Join stage for checking nullability with default value as 0, now my amount columns turnd to 0. I dont know how..

Another method i have tried is that,

In transformer, i am taking two output links with one output link conatins this Null functions and another link as "Input column". If i view the second output link i.e) as input link, iam getting output as "NULL" for all my amount columns.

Kindly let me know for any changes to be done..

Thanks.
Gopinath
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: Join_Null Error

Post by ray.wurlod »

Gopinath wrote:I need a Quick turn around from u guys..
We don't do "urgent".

DSXchange is an all-volunteer forum whose members post as and when they can, if they have something to contribute. If you require speedy response sign up with your support provider for premium services, and learn the true cost of "urgent".

The second person personal pronoun in English is spelled "you".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply