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

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,


I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  


What is shortcut join?could give any one example?

8 Answers  


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  


What task is 98% of the required work of a business analyst?

0 Answers  


How to hide objects or columns?

6 Answers   Infotech,


What is a category?

3 Answers  


HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers   CitiGroup,


I have all the latest SAP – Business Objects - XI Certification Dumps, SABE201: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level One SABE301: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level Two SABE401: BUSINESS OBJECTS Enterprise Certified Professional XI – Level Three SABE501V3.0: BUSINESS OBJECTS Certified Professional – BUSINESS OBJECTS Enterprise XI 3.0 – Update. RDCR201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR301:1 BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR08301: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08401: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 QAWI201V3.0: BUSINESS OBJECTS Certified Professional Web Intelligence XI 3.0 QAWI301V3.0: BUSINESS OBJECTS Certified Professional BUSINESS OBJECTS Web Intelligence XI 3 DMDI201: BUSINESS OBJECTS Data Integrator XI – Level One DMDI301: BUSINESS OBJECTS Data Integrator XI – Level Two You can get Guarantee Pass 100 % Score with these Dumps, If interested in any of the dump, drop me a mail to: srivatsav.2k5@gmail.com with Certification code

7 Answers   IBM, SAP Labs,


In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  


what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers  


Categories