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
- 10382 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 some of modeling tools available in the market?
What is the difference between datawarehouse and bi?
How can we determine what records to extract?
What is application.cfm?
What is the difference between data warehouse and operational systems?
What is the difference between ods and oltp?
What is scd1 , scd2 , scd3?
I have two universes created by two difference database can we join them in designer & report level? How
Explain what are the different methods of loading dimension tables?
Explain me what is vldb?
What is the working process for application.cfm?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What are the various tools? Explain name a few?
what are the other factors of the database on which the loading performance depend?
How to stop a batch?
