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
Why is dimensional normalization not required?
Explain the differences between normalizer and normalizer transformation?
What is perform recovery?
Explain what is analytical or analytic mean?
How to handle multi value dimensions?
What are the tools available for etl?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What are the key columns in Fact and dimension tables?
What are the steps of implementing data warehousing?
How can we do data cleaning?
What does level of granularity of a fact table signify?
List any five applications of data warehouse.
Can you brief about the Data warehouse project you worked on?
Explain about core dimension,
Which columns go to the fact table and which columns go the dimension table?
