Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
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 |
how to overcome overflow of data in a report
Explain when we use aggregate awareness function in designer?
Explain about Short cut join?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
If there is no common dimension? Is it possible to combine two different dataproviders?
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
What is scope of analysis ?
How to get two dimension objects in a same block which are comming from two different contexts ?
what is maximum scope of analysis --> can we define more than 3 levels?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?