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

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

daily how much amount of data send to production?

4 Answers   HSBC,

What are the types of error logs available in Informatica?

1 Answers  

what transformations are used for Variable port?

2 Answers  

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  




Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

How will u pas the data with out debugger?

4 Answers  

For more Informatica Interview Questions Click Here
Categories