DSXchange

Posted: **Mon Dec 26, 2011 8:30 pm**

Hi ,
In lookup stage i am facing an issue
My job

src->trans->lkp->trans->db
             |  
   File---->trans

src input:
A,B,C
1,AA,23
,BB,24
File:
A,B
1,AA
,BB

I am using lookup
Before lookup i am using NulltoValue((A),'Null')from source

But it was not working can any one guide on this

Posted: **Mon Dec 26, 2011 10:50 pm**

First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it.

Now coming to your problem - is there any warning or error in the job logs? Not working means - job is failing, or you are not getting the output?

Posted: **Mon Dec 26, 2011 11:58 pm**

Kirtikumar wrote:First thing - Close the other duplicate post. Second thing - when providing some job design or code and alignment is needed use the code button provided above and using the preview button make sure it looks the way you want it.

Done and done.

Posted: **Tue Dec 27, 2011 1:30 am**

So what's the issue?

DSXchange

lookupstage issue

lookupstage issue