HASH FILE LOOKUPS
Posted: Mon May 24, 2004 5:08 pm
Guys
Here is another situation. I have created a Hashfile lookup in one of my mappings.
In the source master query, the following are the columns:
OLDCOLA, OLDCOLB, OLDCOLC, NEWCOLA, NEWCOLB, NEWCOLC, I was able to manage the OLD AND NEW VALUES BY APPLYING TRIGGERS AT THE DATABASE LEVEL
OLDCOLA AND NEWCOLA are the KEYS.
THE HASHFILE IS JOINED WITH THE SOURCE MASTER QUERY TO LOAD THE CODE VALUE FROM HASH FILE LOOKUP INTO MASTER TARGET TABLE.
NOW, FOR LOADING THE HISTORY TABLE I AM USING THE OLDCOLA, OLDCOLB AND OLDCOLC VALUES TO POPULATE HISTORY RECORDS.
QUESTION ?
CAN I USE THE SAME HASFILE AND JOIN THE SOURCE NEWCOLA, OLDCOLA to get the CODE VALUE for OLD AND NEW.
I know it can be done if I have multiple instances of same hash file. But, is it possible to apply coditions in one hashfile and get old and new CODE VALUES.
Any feedback is appreciated!
Thanks
Here is another situation. I have created a Hashfile lookup in one of my mappings.
In the source master query, the following are the columns:
OLDCOLA, OLDCOLB, OLDCOLC, NEWCOLA, NEWCOLB, NEWCOLC, I was able to manage the OLD AND NEW VALUES BY APPLYING TRIGGERS AT THE DATABASE LEVEL
OLDCOLA AND NEWCOLA are the KEYS.
THE HASHFILE IS JOINED WITH THE SOURCE MASTER QUERY TO LOAD THE CODE VALUE FROM HASH FILE LOOKUP INTO MASTER TARGET TABLE.
NOW, FOR LOADING THE HISTORY TABLE I AM USING THE OLDCOLA, OLDCOLB AND OLDCOLC VALUES TO POPULATE HISTORY RECORDS.
QUESTION ?
CAN I USE THE SAME HASFILE AND JOIN THE SOURCE NEWCOLA, OLDCOLA to get the CODE VALUE for OLD AND NEW.
I know it can be done if I have multiple instances of same hash file. But, is it possible to apply coditions in one hashfile and get old and new CODE VALUES.
Any feedback is appreciated!
Thanks