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 |
What is mean by stored procedure ? and how we can generate stored procedure universe?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
what is variable ?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
what is profile and packages in BOXI??
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
What are the errors u have faced in creating reports in business objects and explain some?
HOW TO SPOT A HIERARCHY?