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 are situations where snow flake schema is better than star schema to use and when the opposite is true?
Tell me what is degree of a relation?
Is union transormation is active transformation?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Where the applications and where
Explain me what are data marts?
Explain the definition of normalized and denormalized view?
how much memory space occupied real time project (roughly)?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what is the data type of the surrogate key?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What function should we use to display the value entered or selected by a user in response to a prompt?
How to improve session performance in aggregator transformation?
Explain what are the basic needs to join two sources in a source qualifier?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
