Sign Up Login


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

what is the purpose of surrogate key and diff between primary
key&surrogate key

Question Posted / ahalya inturi


what is the purpose of surrogate key and diff between primary key&surrogate key..

Answer / suresh

primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.

surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More Informatica Interview Questions

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

What are the reusable transforamtions?

1 Answers  

what are cost based and rule based approaches and what is the difference?

1 Answers  

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

What is the functionality of update strategy?

2 Answers  

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

what are the transformations that restricts the partitioning of sessions?

1 Answers  

For more Informatica Interview Questions Click Here
Categories