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
Whether dimension table can have numeric value?
What is vldb(very large databases)?
Explain how to export mappings to the production environment?
Explain the difference between data ware house & data mart?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Why is chameleon method used in data warehouse?
What needs to be done while starting the database?
List down some of the real time data-warehousing tools?
What are the methodologies of data warehousing?
what type of raid setup would you put your tx logs?
what are relationships?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
How many project sources we can create in metadata?
What is the difference between junk dimension and degenerated dimension?
what are the all possible features supported modify stage?
