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                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 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
What is a surrogate key?Why we use it in a mapping?Pl give 
an example.
 Question Submitted By :: Mercy
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is a surrogate key?Why we use it in a mapping?Pl give an example.
Answer
# 1
surrogate key is a System generated Key ( Artificial 
key ),Every join between dimension tables and fact tables 
in a data warehouse environment should be based on 
surrogate keys, not natural keys.
There are still more reasons to use surrogate keys. One of 
the most important is the need to encode uncertain 
knowledge. You may need to supply a customer key to 
represent a transaction, but perhaps you donýt know for 
certain who the customer is. This would be a common 
occurrence in a retail situation where cash transactions 
are anonymous, like most grocery stores.
 What is the customer key for the anonymous customer? 
Perhaps you have introduced  a special key that stands for 
this anonymous customer. This is politely referred 
to as a "hack."
 
Is This Answer Correct ?    4 Yes 1 No
Srinu
 
  Re: What is a surrogate key?Why we use it in a mapping?Pl give an example.
Answer
# 2
surrogate key is used to avoid the critical column.critical 
column means the column which makes the analysation or data 
wrong for example assume one customer table 
cust_id(p.k)  cust_name  amount  loc
1              jones       1000   hyd
he purchase the product in hyd by 1000/- if he again 
purchase by 2000/- in pune not in hyd.then we have to 
create another record in that table with same cust_id but 
here cust_id is having primary key so we are unable to 
create a new record for suppose if u update the record u 
got the wrong information as 
1    jones  3000  pune 
so eliminating this we are maintian the another column like
cust_no as surrogate key (unique value)and removes p.k in 
cust_id.surrogate key is like an index.
 
Is This Answer Correct ?    3 Yes 1 No
Saradhi
 
 
 
  Re: What is a surrogate key?Why we use it in a mapping?Pl give an example.
Answer
# 3
IT IS UNIQUE KEY AND ITS USED FOR COMPARING THE EMPLOYEE DETAILS
 
Is This Answer Correct ?    0 Yes 1 No
Venkadesh
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
how do u get the first record from 50,000 records ? TCS7
What are the challenges of Dataware housing in the future? HP2
What are mapping parametres and variables in informatica? TCS3
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session?? TCS5
if we r using aggregator we enabled sorted input but the records r not sorted what happen? HSBC7
What are the new features of the server manager in the informatica 5.0?  1
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in  1
How will you display "Mr" for male & "Mrs" for female in target table?  4
What is the target load order?  3
what are the reusable tasks in informatica ? IBM5
HOW TO GET THE LATEST DATA IN SCD ? TCS3
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how CTS3
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?  3
What is the difference between view and materialised view?  5
What are the mapping paramaters and mapping variables?  1
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this. TCS2
difference between shortcut and reusable transformation?  2
what is confirmed dimension?  4
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com  1
Where should yoU place the flat file to import the flat file defintion to the designer?  2
 
For more Informatica 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