DSXchange

i have requrement like this ........

previous we have 2 DB2 file contain LOAN TYPES LIKE (1,3,8) we are applying filter condition but now are removing filetr condtion in place of hardcoding . now what we did na we creating one more table that contains laon types like 1,2,3,4.......in place of hardcoding we are refering this table how to maping......this three tables

please help me

What is your exact requirement?
Do you want extract the records from the table? Give us your business requirement

u have source file contain LNTYPE this loan we extracted throught lookup
this look up file contains query like this SELECT * FROM TABLE_NAME WHERE WHERE PROD_TYPE IN (1,3,8) .but now we removing the this filetr logic we need to extracts all products this perpose we created one more table ETL_PARAMETR table this table contains LNTYPE ,PROD (PKs) so we need to replace in place of hard coding prod _TYPEs so we need to use this theree tables how to look up this 3 tables plz help me ASP

Perform a join using user-defined query.

agree with gateleys. You can do multiple lookups but it will be tedious.

Please try and post clear requirments. I had to read it thrice to understand what you wanted.