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
Explain bus schema?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain the versions of reportnet?
Compare and contrast aggregates & indexes
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How many types of facts and what are they?
Ist the schema that a data warehouse system can implements.
Explain grouped cross tab?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain the differences between normalizer and normalizer transformation?
ware house management system is used?
How can we load the time dimension?
What is meant by metadata in context of a data warehouse and how it is important?
Explain conformed fact?
How to calculate fact table granularity?
