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...


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 the difference between star and snowflake schemas?

0 Answers  


Describe the differences between a data warehouse and data mart.

0 Answers  


What is a data warehousing?

0 Answers  


What is your spectra photometer working principles?

0 Answers  


Explain me what is vldb?

0 Answers  


What are algorithms provided by Microsoft in SQL Server?

0 Answers  


What are steps we have to follow in designing the userfriendly universe?

0 Answers  


I need to set predefined condition. How I do this?

0 Answers  


Explain dimensional modelling?

0 Answers  


three ways sql*loader could load data, what are those three types?

1 Answers  


Difference between cold fusion mx 6 and cold fusion mx 7?

0 Answers  


What is ETL process in Data warehousing?

3 Answers  


Categories