DSXchange

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.

Change your "Lookup Failed" rule.

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.

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

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.

---Its Varchar

Two questions, one answer. Batting 500.

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

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.