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
some look up issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2007 1:06 am
-
- Participant
- Posts: 44
- Joined: Fri Mar 16, 2007 5:51 am
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
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
seshu
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio