ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
What is the use of Surrogate key in BO?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the use of Surrogate key in BO?
Answer
# 1
Surrogate key is the dummy key which is used to allow the
duplicate values
 
Is This Answer Correct ?    0 Yes 0 No
Kumaravel.s.t
 
  Re: What is the use of Surrogate key in BO?
Answer
# 2
Surrogate key is contigeous numbers generated by DB in a 
table which acts as a primary key since surrogate key has 
unique values.

for eg : 
101,102,103,104,105............ so onl
 
Is This Answer Correct ?    0 Yes 0 No
Ravinder Singh
 
 
 
  Re: What is the use of Surrogate key in BO?
Answer
# 3
Surrogate Key is a primary key in datawarehousing, the only
difference between surrogate key and primary key is that
surrogate key allows duplicate values but not primary key.
 
Is This Answer Correct ?    0 Yes 0 No
Handy
 
  Re: What is the use of Surrogate key in BO?
Answer
# 4
Surrogate key is unique key which is used in type 2 
dimension.
 
Is This Answer Correct ?    0 Yes 0 No
Chandru
 
  Re: What is the use of Surrogate key in BO?
Answer
# 5
When we transfer the data from the source to the target
tables i.e dimension tables,we will be having one primary
key for the dimension table,but in the scd type 2 will be
having the repetative data i.e history+current data,so we
will be using the surrogate key for the dimension tables for
identifying the 
rows uniquely this surrogate is implemented in the ETL
process by using the "Sequence Generator Transformation".

            The surrogate key will be act as primary key in
the scd type 2 and primary of dimension table will be the
natural key.
 
Is This Answer Correct ?    2 Yes 0 No
Sri
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
What is the difference between master-detail and Breaks?  3
Can we have multiple domains?  3
how do we apply sql query on selected variables?  3
Explain in Detail about Measure Objects? and what is the use of it? How to create it?  4
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode HP1
whats the diff between break and section TCS1
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?  2
What is the use of Surrogate key in BO? IBM5
How to link two different universes ?  3
HOW DO YOU SCHEDULE THE REPORTS?  5
How can we acheive Correlated sub-query in Designer? Wells-Fargo1
what is dashboards? what is metrics? TCS4
How toconnect one to one report? iFlex3
how many micro cubes can a report can have  1
3.what is alias? TCS5
What is thin client And thick client..?  2
What is casual dimension?  2
4.what is aggregate awareness ? how do we use ? where do we use ? Accenture1
what is fantrap and chasmtrap ? Tech-Mahindra2
how to do Ad-hoc reporting ? IBM4
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com