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
- 10224 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
How can we load the time dimension?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
Explain functional dependency?
What according to you might be the future of data warehousing?
How are models actually derived?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Where can one get more info about Data Warehousing?
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?
What is incremintal loading?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
I need a good brd and uc template?
Teradata 
