top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

OBIEE: What is a surrogate key?

+1 vote
620 views
OBIEE: What is a surrogate key?
posted Aug 10, 2016 by Abhimanyu Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.

answer Aug 17, 2016 by Manikandan J
...