Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the steps of implementing data warehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is data analysis?
Explain how many ways you create ports?
How are models actually derived?
How do we design a universe?
What is the difference between power center & power mart?
What are aggregate transformation?
What is your spectra photometer working principles?
Why should we use data ware housing and how can you extract data for analysis with example?
How can you implement many relations in star schema model?
How can you set the session management?
What are modeling tools available in the market?
Can a dimension table contain numeric values?
Explain the versions of reportnet?
