suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 9035 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 |
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is the difference between Oracle Express and Oracle Discoverer?
What is operational data source (ODS)?
What are the advantages and disadvantages of reporting directly against the database?
How to calculate fact table granularity?
What is data analysis?
Explain the importance of data warehouse?
I know of using applysimple, but there are other ways too?
What Oracle tools can be used to design and build a W/H?
What are the primary ways to store data in OLAP?
Explain the different types of data warehousing?
What is a functional dependency f said to be minimal?
Teradata 
