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
How to reduce warnings?
Explain what is fact less fact table? Where you have used it in your project?
I have two universes created by two difference database can we join them in designer & report level? How
The same tier?
What is the extension of file to save template?
Explain what is the difference between view filter and report filter?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
How are the dimension tables designed?
Explain meta data?
Explain what are the different types of data warehousing?
What are the reasons to use a chameleon method in data warehousing?
How can we run the graph? What is the procedure for that?
Explain what are the vaious etl tools in the market?
What is the main difference between schema in rdbms and schemas in datawarehouse?