Lookup not working
Moderators: chulett, rschirm, roy
Lookup not working
Hi Friends,
When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.
When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Lookup not working
deesh wrote:Hi Friends,
When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.
""" I given Continue option""" In the same lookup I given two reference keys from two tables
Table1 Table2
1. opt1- sid
2.opt2- ikid -------> Table3
Second reference key is not working, First one is good.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Lookup not working
---Its Varchardeesh wrote:Hi Friends,
When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.
ROTFLMAOchulett wrote:Two questions, one answer. Batting 500.
(Sorry for the acronym Ray
![Smile :)](./images/smilies/icon_smile.gif)
deesh, what Craig is getting at is if your source data is "FOO " and your lookup is "FOO" you won't get a hit. This one has bitten me in the past.
So, as Craig said, make sure your data is trimmed equivalently. If you're not sure, print something like "^":your_data:"$" for both data elements to the log.
Some people are the Michael Jordan's of Datastage. I'm more like Muggsy Bogues ![Smile :-)](./images/smilies/icon_smile.gif)
![Smile :-)](./images/smilies/icon_smile.gif)
Re: Lookup not working
I am prepared same condition for two jobs but one job is working, second one is not working i given same conditions but not working.deesh wrote:Hi Friends,
When I am look uping data, look up is not working, data is coming as null but data is there, Moreover job is not showing any warning and failures.