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

Is there any target staging area in informatica not staging area

0 Answers   Syntel,


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


what is data driven?

1 Answers  


what is materialized view?

2 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,






In joiner, how to load Master table in Target?

2 Answers  


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  


What is a unit Testing?

1 Answers  






Categories