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

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

Question Posted / shaj

Answer Posted / shaj

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which columns go to the fact table and which columns go the dimension table?

962

Explain what is the difference between powerplay transformer and power play reports?

1163

Explain me what are data marts?

1053

Can we take backup when the database is opened?

1059

Explain piconet?

968

What is data type of the surrogate key?

1004

Define Data Warehousing?

1155

Explain what is partitioning? What are the types of partitioning?

973

Start a batches with in a batch?

980

What is the difference between aggregate table and materialized view?

1105

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

902

What is the difference between datawarehouse and bi?

962

Explain the definition of normalized and denormalized view?

903

Explain some of modeling tools available in the market?

969

Explain what are the possible data marts in retail sales?

1015