ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
suppose data are coming from different locations and those 
data will not change . is there any need to use surrogate key ?
 Question Submitted By :: Itsranjan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Answer
# 1		 
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 ?    1 Yes 0 No
Suri
 
  Re: suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Answer
# 2		 
Yes, we need to add the surrogate key in table.
 
Is This Answer Correct ?    1 Yes 0 No
Shaj
 
 
 
  Re: suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Answer
# 3		 
yes there is the use of surrogate key
 
Is This Answer Correct ?    0 Yes 0 No
Deepthi
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What is data merging, data cleansing and sampling?  1
how can one connect two fact tables ? is it possible ? how? ABC6
what is indexing ? what are different types of indexes supported by oracle ?  2
What is confirmed dimension?  3
What is ETL process in Data warehousing?  2
5.Explain ODS ? HCL1
what is the difference between etl tool and olap tools  3
What is MDX? TCS1
What is source qualifier?  1
Where can one get more info about Data Warehousing? TCS2
Why do we use DSS database for OLAP tools?  2
Compare ?Data mining? and ?Data Warehousing??  2
which automation tool is used in data warehouse testing?  1
What is an OLTP (Online Transaction Processing) System?  2
How can you define a transformation? What are different types of transformations in Informatica? TCS3
What is DTS ?  1
What is surrogate key? IBM4
Tell me one example for multi valued dimension or bridge table? TCS1
What is the "junk dimension"? Give with examples?  3
three ways sql*loader could load data, what are those three types?  1
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com