Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / meena
A surrogate key in a database is a unique identifier for
either an entity in the modeled world or an object in the
database. The surrogate key is not derived from application
data.
There appear to be two definitions of a surrogate in the
literature. We shall call these surrogate (1) and surrogate
(2):
Surrogate (1) This definition is based on that given by
Hall, Owlett and Todd (1976). Here a surrogate represents
an entity in the outside world. The surrogate is internally
generated by the system but is nevertheless visible by the
user or application.
Surrogate (2) This definition is based on that given by
Wieringa and de Jung (1991). Here a surrogate represents an
object in the database itself. The surrogate is internally
generated by the system and is invisible to the user or
application.
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What is degenerate dimension table?
Explain what are the modules in power mart?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what are the various file formats involved in reportnet?
What are algorithms provided by Microsoft in SQL Server?
What is the difference between junk dimension and degenerated dimension?
Explain the hierarchies level data warehousing.
What is a source qualifier?
Why fact table is in a normal form?
What is difference between e-r modeling and dimensional modeling?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
List down some of the real time data-warehousing tools?
Fact table is in normalized or de-normalized form?
What is the difference between constraind base load ordering and target load plan?
What is the use of dimensional modeling in data warehousing?
