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  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 ?    1 Yes 4 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 ?    3 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 2 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 1 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 ?    6 Yes 1 No
Sri
 
  Re: What is the use of Surrogate key in BO?
Answer
# 6
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 ?    1 Yes 1 No
Bhaskar
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.  3
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it? IBM1
How will you know the version of Bo using designer?  3
Can any one say me wat does"maintanence of universe" means wit? TCS2
How many tables can an universe contain is their any limit to insert tables in the universe?  3
in xir2 how to send reports to end user TCS2
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.  1
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash  2
What are the general issues in migration process?  3
What are the Errors in BO Pls Explain with Examples iFlex2
9.what are the multidimensional analyses TCS4
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr? TCS1
How to Implement the the Built-in Strategy Script in BO Designer? Infosys2
How do u get requirement from the client? in what format? TCS1
what happens if cardinalities are not resolved? PCS3
how we improve the performance of report and universe? IBM2
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM? CitiGroup3
What services the broadcast agent offers on the server side? TCS1
i want to take a report 10 records per page. How to take it? is there any paging option in BO? IBM1
Can We customize the Business Object infoview in BO?  2
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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