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 Conceptual, Logical and Physical model?
How to stop a batch?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
if source contain 10records how you identify header and footer
How do you setup Lo-cockpit?
Explain what are the different types of join operations?
Start a batches with in a batch?
Explain Process flow in data warehouse??
Code the tables statement to produce a multi-level frequency?
What are the differences between star and snowflake schema?
Can decision tree be implemented using SQL?
how to find unique records in informatica level