Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

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

Question Posted / itsranjan

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

Best Data Ware housing training institute in delhi

3 Answers  

What are aggregate tables and aggregate fact tables?

0 Answers  

What is a fact table?

1 Answers  

What is an OLTP (Online Transaction Processing) System?

4 Answers  

1.WHAT IS DATA MART ?

5 Answers   HCL,

Which component has onread method and what it is used for?

0 Answers  

What is the difference between view filter and report filter?

0 Answers  

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

0 Answers  

What is VLDB?

0 Answers  

Explain about Control M JObs detaily?How to execute this.

2 Answers   Scope International,

Is union transormation is active transformation?

0 Answers  

What are the methodologies of data warehousing?

0 Answers  

For more Data Warehouse General Interview Questions Click Here
Categories