Answer Posted / maruthi
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 ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of Dataware Control?
Explain difference between data ware house & data mart?
What are session timeout and application timeout? Where we have to do this process?
What is degenerate dimension table?
How can you communicate with web server (apache or iis) from coldfusion?
What are the key features of chameleon that separates it from other algorithms?
Which are the olap tools available that are supported by oracle?
What are universe requirements?
Explain me what are conformed dimensions?
What are non-additive facts in detail?
Explain what are components of report studio?
What are snapshots? What are materialized views & where do we use them?
What is a real-time data warehouse?
Briefly state different between data ware house & data mart?
Explain what is a view as it relates to system modeling?
