suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 9298 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 |
What are the stages that are required in data warehousing?
Explain what is a three tier data warehouse?
Can you state some of the innovations throughout history?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Which are the olap tools available that are supported by oracle?
Name a few sectors which use data warehousing?
Explain is fact table?
Explain is olap databases are called decision support system true/false?
How we are using this function?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Explain what is data validation strategies for data mart validation after loading process?
Teradata 
