![Smile :)](./images/smilies/icon_smile.gif)
We have a look up to be used while loading data to the target table.
The look up has to be updated automatically whenever the table is updated.
i.e. the lookup should be dynamic.
We have created one table for look up (eg SETID lookup) and inserted one row.
We ran the hash load before running the server job for the first time.
Now one more row has been inserted into the look up table.
If we run the server job without running the hash load, the look up is having only one row.
Its not getting updated whenever the table has changed.
Our requirement is without running the hash load, we want the data to be updated in the hash file.
Can u pls suggest me how to implement the dynamic hash concept?
Regards
Avishek