suppose data are coming from different locations and those data will not chang

suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?

Question Posted / itsranjan

3 Answers
10237 Views
Oracle, I also Faced
E-Mail Answers

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 cubes?

0 Answers

What are the different types of datawarehosuing?

0 Answers

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

0 Answers

What is execution plan?

0 Answers

Explain what are slowly changing dimensions?

0 Answers

if we increase the number of dimensions will the rows in fact table increase or decrease??

3 Answers IBM,

What is ods (operation data source)?

0 Answers

State any 5 of Cods guidelines of an OLAP system, brief description each?

1 Answers

What are the main steps to build the data warehouse?