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 a general purpose scheduling tool?
What is operational data store (ods)?
What is dimension modeling?
Can you brief about the Data warehouse project you worked on?
What is cubes?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is type 2 version dimension?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain the difference between oltp and olap?
Explain the data type of the surrogate key?
What are the various methods of getting incremental records or delta records from the source systems?
Explain meta data?
What is perform recovery?
How to eliminate duplicate rows from flat file?
