Answer Posted / msb.dwh
SURROGATE KEY IS SYSTEM GENERATED PRIMARY KEY
1)THIS IS USED WHEN DATA COMMING FROM MULTIPLE SOURCES THEN
THERE IS CHANCE OF DUPLICATION SO WE USED THIS
2) THE P.KEY ON TABLE MAY HAVE ANY DATATYPE BUT NO(S.KEY)
ACCUPYES VERRY LESS SPACE
3)MENTAING THE QUARY IS SIMPLE FOR END USER
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is the difference between constraind base load ordering and target load plan?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain what is a three tier data warehouse?
Whether dimension table can have numeric value?
What is difference between query studio and report studio?
What is the use of dimensional modeling in data warehousing?
Give some difference between oltp and olap.
if you use oracle sql*loader , how do you transform data with it during loading?
I need to set predefined condition. How I do this?
What are Aggregate tables?
What is difference macros and prompts?
What is a Decision Tree Algorithm?
What is a relationship?
Compare and contrast aggregates & indexes
What is surrogate key? Where we use it? Explain with examples.
