Interested to Buy Any Domain ? << Click Here >> for more details...
Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
- 7 Answers
- 10589 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 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?
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.
What is shortcut join?could give any one example?
How to create an popup in the WEBI report if the report is showing partial result?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What task is 98% of the required work of a business analyst?
How to hide objects or columns?
What is a category?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
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
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.
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
Teradata 
