Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
Answer Posted / 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 |
Post New Answer View All Answers
what are the tables used in health care domain project and columns used in report?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
what is xcelsius architecture?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is object stores?
Explain when we use aggregate awareness function in designer?
Explain what task is 98% of the required work of a business analyst?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Differences between business objects and web intelligence reports?
how many reports have u created ? explain a few.
What are the steps to do to use alerts in bo?
Can you please send me the migration related issues .
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is the functional & architectural differences between business objects and web intelligence reports?