Home > Data Warehouse, SSIS > Lookup Table

Lookup Table


Just a concept. It has been already discussed by data management experts. But, I just renew the thoughts.

What is OTLT (One True Lookup Table) or common lookup table or single source lookup table?
It is a place or a table to keep all the lookup data and maintain the single source for the data management. For instance, data loading for DWH.

Benefits:
-Easy manageability, which is the most necessary component of the life cycle of the data warehouse.
-Single source of data truth

I am stopping here for you to comment about the topic and further discussion.

Advertisements
Categories: Data Warehouse, SSIS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: