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
Explain why denormalization is promoted in universe designing?
Explain Association algorithm in Data mining?
What is a data profile?
Where we use surrogate key explain with example?
Explain what is ods (operation data source)?
Explain about core dimension,
What are the advantages of raid 1, 1/0, and
Is union transormation is active transformation?
What are the advantages of query studio compared to report studio?
Explain ddl (data definition language)?
What is latest version of power center / power mart?
Is there any default username & pwd for bo designer & supervisor?
What according to you might be the future of data warehousing?
what is an use case?
Whether dimension table can have numeric value?
