Lookup not working

[deesh]

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.

[ray.wurlod]

Change your "Lookup Failed" rule.

[deesh]

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.

[ray.wurlod]

What are the data types of the lookup keys? If string, are they equivalently trimmed?

[deesh]

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.

---Its Varchar

[chulett]

Two questions, one answer. Batting 500.

[sbass1]

Two questions, one answer. Batting 500.

ROTFLMAO

(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.

[deesh]

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 am prepared same condition for two jobs but one job is working, second one is not working i given same conditions but not working.

[chulett]

Stop quoting yourself. And something is different between the two or both would be working. Do both jobs process the same data? Perhaps the second one needs more 'conditions' to handle it properly.