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



suppose data are coming from different locations and those data will not change . is there any nee..

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

suppose data are coming from different locations and those data will not change . is there any nee..

Answer / shaj

Yes, we need to add the surrogate key in table.

Is This Answer Correct ?    2 Yes 1 No

suppose data are coming from different locations and those data will not change . is there any nee..

Answer / deepthi

yes there is the use of surrogate key

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is Conceptual, Logical and Physical model?

1 Answers  


How to stop a batch?

0 Answers  


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

2 Answers   Polaris,


How do you setup Lo-cockpit?

0 Answers  






Explain what are the different types of join operations?

0 Answers  


Start a batches with in a batch?

0 Answers  


Explain Process flow in data warehouse??

1 Answers   BirlaSoft,


Code the tables statement to produce a multi-level frequency?

0 Answers  


What are the differences between star and snowflake schema?

0 Answers  


Can decision tree be implemented using SQL?

0 Answers  


how to find unique records in informatica level

1 Answers   IBM,


Categories