suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
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
What is the metadata extension?
What is the difference between snowflake and star schema?
Explain what is power center repository?
Ist the schema that a data warehouse system can implements.
Explain what is the difference between powerplay transformer and power play reports?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain what is fact less fact table? Where you have used it in your project?
What is the difference between data warehouse and operational systems?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is the function of surrogate key in data warehousing?
what is user variable in affinium campaign? and some real time examples.
What is real-time datawarehousing?
Suggest a good author for hyperion in data warehousing?
What is the difference between olap and oltp?