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
Explain the main differences between star and snowflake schema?
Explain what is full load & incremental or refresh load?
What is VLDB?
Difference between e-r modeling and dimentional modeling?
Why should we use data ware housing and how can you extract data for analysis with example?
What is the difference between Datawarehouse and OLAP?
What are the various methods of getting incremental records or delta records from the source systems?
Explain about core dimension, balanced dimension, and dirty dimension?
What is the difference between a primary and secondary actor in use case modeling?
How can we schedule the graph in unix?
Explain what are the basic needs to join two sources in a source qualifier?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Can you pass sql queries in filter transformation?
How to handle multi value dimensions?
What is drilling across?
