DSXchange

search for "remove Duplicate"

remove the line , where written like :

/*NT*/ \\.\pipe\tdmpipe_DSLink71. AXSMOD np_AXSMOD.dll

And it can have 100 distinct values if the parameter have 100 values, how are you using it in A.THREADID = #THREAD# ---------------------- you can put all the values in a sequential file. and then design a job to read the sequential file have a lookup stage to read data from the oracle table, using...

My DBA is forcing to use a bind variable in input query instead of a job parameter.

Why??
can you post the input query?

Then 1st dump the both table in one database and use database join.

put a transformer in between the lookup and target stage, and if the value from the reference link link is NULL then set the values to "no records found"

Actually the same job works well in Development server . But when I export/import into UAT Server , its not working . Someone please help ASAP

are you using the same Oracle user and same database in UAT server also??

check this post and try setting those parameters,.
viewtopic.php?t=121263

But in my query when I put key_column=orchestrate.key_column the job fails.

Fail with what error ? whats in the message??

explain your job? what are you trying to do in the job?

i think this could be designed quit easily in server job, by writing into a hashfile and do lookup the same hash file.

what are the reference link sources?
if they are tables, try sparse lookup.
Else try join

did you tried writing the query in oracle stage as user defined query.
what error you get?

design a job to read from the oracle table, using oracle enterprise stage and load into the target table using oracle enterprise stage.

post the error or any problem you are having.

it's O/S user id and password