Interested to Buy Any Domain ? << Click Here >> for more details...
Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
- 7 Answers
- 10673 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dr.karthik
In a current database, the surrogate key is the primary key,
generated by the database management system and not derived
from any application data in the database. The only
significance of the surrogate key is to act as the primary key.
Dr.Karthik.k
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vidya
Surrogate Key is unique identifier Key in Production
System, to avoid data duplication and redundancy in DWH
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nareshkumar
A surrogate key is a substitution for the natural primary
key. It is just a unique identifier for each row that can
be used for the primary key to the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pravin
surrogate key is a system generated key which is defined at
database level to avoid the duplication of records it dosent
mantain any relations btwn tables like as primary key and it
only allows unique data there is a command with sequence in
oracle..just check it out
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / vidhya
Surrogate key: Also known as Sequence id in ORACLE or
Identity column in SQL SERVER (whatever you call to your
convenience).Auto generated keys by the system.
DWH: Used here as a substitute of existing primary key to
encourage duplicates and thereby misleading the rule of
third normal form. Thus maintaining the history of records
which supports SCD(slowly Changing Dimension III)
3NF: Each table should have one primary key
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / swades
an artificial key which can be used to remove redundancy
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / arun3409
A surrogate key is an automatic system generated unique key.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is diff between webi,deski,infoview
How to create universe in business objects enterprise 11.5
how to do Ad-hoc reporting ?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
What is meaning of fullpath client in business objects?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can more than 1 metric be applied on an analytic in business objects?
Explain what three things do you consider to be the most important factors for a manager?
how to limit number of rows in a report in business objects using webi?
what are cascading prompts explain with steps
Have you worked with multiple data sources? If yes. How do you link them?
Teradata 
