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 ods (operation data source)?
Explain what are the methodologies of data warehousing?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is the purpose of Dataware Control?
Which are the olap tools available that are supported by oracle?
Where the applications and where
What are diagrams?
Explain can a dimension table contains numeric values?
How to create diff. Types of templates?
Explain bus schema?
What is data cleaning? How can we do that?
For faster process, what we will do with the universe?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
what are different storage options supported by oracle ?
What according to you might be the future of data warehousing?