what is the use of surrogate key in businessobjects
Answer Posted / samir kumar sahoo
A Surrogate key is a system generated key which is assigned
to be a primary key in the system(table).When data coming
from multiple data sources then there will be a possibility
of duplications and at that situation the system uses the
surrogate key in order to mantain data consistency.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is Operational Data Store?
Explain how are the dimension tables designed?
How to pivot row data using informatica?
What we will do with the universe for faster process?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is pre-emptive and non-pre-emptive?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is many-to-many dimensional model in datawarehousing ?
What are the types of dimensional modeling?
Explain dimensional modelling?
What is the difference between ods and oltp?
Explain the versions of reportnet?
How to create prompts in report net?
Explain er diagram?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....