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 It's probably not "business level" English either!)
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
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.