Interested to Buy Any Domain ? << Click Here >> for more details...
suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 9998 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / suri
Yes, We should use the surrogate key, here we are geeting
data from different locations means every one have one
primary key, while transforming the data into target that
time morethan two key not in use so if you use surrogate
key it will identified the duplicate fields in dimensional
table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain what is power center repository?
Explain me what is vldb?
What is a source qualifier?
How are models actually derived?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are data modeling and data mining? Where it will be used?
Explain how to generate iqd file from framework manager?
What is the difference between er modeling and dimensional modeling?
What is surrogate key? Explain with examples.
What is a relationship?
Explain a relation schema and a relation?
Can you state some of the innovations throughout history?
Can we start and stop single session in concurent bstch?
How can we do data cleaning?
Explain what is the difference between power center & power mart?
