suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
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 the difference between star and snowflake schemas?
Describe the differences between a data warehouse and data mart.
What is a data warehousing?
What is your spectra photometer working principles?
Explain me what is vldb?
What are algorithms provided by Microsoft in SQL Server?
What are steps we have to follow in designing the userfriendly universe?
I need to set predefined condition. How I do this?
Explain dimensional modelling?
three ways sql*loader could load data, what are those three types?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is ETL process in Data warehousing?