Saved Bookmarks
| 1. |
What Is A Lookup Table? |
|
Answer» A lookUp table is the one which is used when updating a warehouse. When the lookup is PLACED on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by ALLOWING only new RECORDS or UPDATED records based on the lookup CONDITION. A lookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition. |
|