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






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 1 No

Post New Answer




More Informatica Interview Questions

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


design of staging area?

0 Answers  


How to improve the session performance in informatica?

3 Answers   Accenture,


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  






What is partioning?how many types of partinings are there

2 Answers   HCL,


How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


what is mapping performence?

2 Answers   Cap Gemini,


There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,


From where we can start or use pmcmd?

3 Answers  


What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  


How the dimensions will be loaded?

0 Answers   HCL,






Categories