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
- 9997 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 is difference between model & package?
Explain difference between view and materialized view?
What are the steps involved in designing a fact table?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Database in use is oracle?
What is data validation strategies for data mart v?
how can one connect two fact tables ? is it possible ? how?
Who needs data warehousing?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is an OLAP (On-line Analytical processing) system?
Explain what is metadata reporter?
Teradata 
