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
- 10227 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
What are the various tools? Explain name a few?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain what are non-additive facts in detail?
Explain what are non-additive facts?
Explain functional dependency?
Explain the difference between filter and conditin?
What are the methodologies of data warehousing?
What is the 4 + 1 view model as it relates to system modeling?
What are the different types of fact tables used in data warehousing?
How are models actually derived?
What is core dimension?
Can we start and stop single session in concurent bstch?
Explain what are slowly changing dimensions?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
