Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can any body will explain about sarrogat key?
Thanks in advance...........Prakash

Answers were Sorted based on User's Feedback



Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

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

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

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

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

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

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

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

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

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

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

Answer / swades

an artificial key which can be used to remove redundancy

Is This Answer Correct ?    0 Yes 1 No

Can any body will explain about sarrogat key? Thanks in advance...........Prakash..

Answer / arun3409

A surrogate key is an automatic system generated unique key.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Business Objects Interview Questions

difference between xir2 and 6.5 version

4 Answers  


What is report template in b.o?

0 Answers  


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

0 Answers   IBM,


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,


When we are going for Shortcut join and why.

1 Answers   Cap Gemini,


WHAT IS ROW LEVEL SECURITY IN BO?

7 Answers   Wipro,


How many built-in objects are created in Business Objects repository?

2 Answers  


What is the dense rank?

0 Answers  


how to schedule a report for even number dates?

2 Answers   HCL,


How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,


can anybody tell me about issues faced while creating reports

1 Answers   Accenture, Tech Mahindra,


how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,


Categories