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 |
Explain the main difference between inmon and kimball philosophies of data warehousing?
What are aggregate fact tables ? why they are needed? give an example
What does level of granularity of a fact table signify?
What are loops in Datawarehousing?
What is cost benefit analysis (cba)?
Explain multivalued dependency?
What is an OLTP (Online Transaction Processing) System?
Define data warehouse?
What is aggregate fact table?
How to calculate fact table granularity?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Start a batches with in a batch?