Jump to content
Changes to the Jaspersoft community edition download ×

What will be benefit of surrogate key in data warehosue layer?


rajneeshshukla

Recommended Posts

Hello Experts,

OLTP source tables are having surrogate keys (numeric values) and natural keys (alphanumeric values), then can I skip creating surrogate keys in target OLAP DB (Dimensional Model) for dimension tables.
I know that I will need surrogate keys for fact tables as uniquke key for fact table will be a large set and I will need a single columns with numeric values as primary key there.
I am joining mutiple source tables for populating data into one dimension target then I am wondring to use unique id (numeric values) of driving table (this id is inherited from OLTP source) as primary key , provided that data granularity of resulted record is at driving tables' id level (resulted record is the record after main source driving table is joined with other source tables).

What will be benefit of surrogate key in data warehosue layer?

Thanks,
Rajneesh

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...