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 are the advantages of raid 1, 1/0, and
What are the different ways to represent the loading of dimension tables?
What are the reasons to use a chameleon method in data warehousing?
Explain the versions of reportnet?
Explain vldb?
What is the use of dimensional modeling in data warehousing?
Tell me what is full load & incremental or refresh load?
Explain is fact table?
What is the 4 + 1 view model as it relates to system modeling?
Explain what are data marts?
Explain which are the olap tools available that are supported by oracle?
What is aggregate fact table?
How do you setup Lo-cockpit?
What according to you might be the future of data warehousing?
Explain er diagram?
