The Definitive Guide to Data Quality
I want to use lookup table in my job.
The scenario is I have one input table, one lookup table and one output table. I want to insert one output field from lookup table, which match with two fields from input table with respective two fields of lookup table. If condition satisfy then returns another field as output from lookup table to output table.