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 differences between datamart vs. Reporting cube?
I know of using applysimple, but there are other ways too?
Why should you put your data warehouse on a different system than your oltp system?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is a data warehousing?
What is latest version of power center / power mart?
What is a hash cluster?
Whether dimension table can have numeric value?
Start a batches with in a batch?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are parallel querys and query hints?
in general which algorithms for used?
What is data type of the surrogate key?
What a static and local variable?
Explain what is the difference between olap and datawarehosue?