Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a functional dependency f said to be minimal?
Explain what are the different types of data warehousing?
what are relationships?
What is the limit to the number of sources and targets you can have in a mapping?
Explain what is the difference between power center & power mart?
Database in use is oracle?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is Active Datawarehousing?
What is a hash cluster?
What are the types of partitioning?
Tell me what is full load & incremental or refresh load?
What do you mean by static and local variable?
What is data warehouse architecture?
Store (and count) non-fact records?
Difference between PowerPlay transformer and power play reports?
