surrogate keys usage in Oracle and Informatica?

Answers were Sorted based on User's Feedback



surrogate keys usage in Oracle and Informatica?..

Answer / ranjan

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Is This Answer Correct ?    6 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / avinash kumar

If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica

Is This Answer Correct ?    6 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / mahendra reddy ongole

surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications

Is This Answer Correct ?    4 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / palani

Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.

Is This Answer Correct ?    1 Yes 0 No

surrogate keys usage in Oracle and Informatica?..

Answer / tanmoy

A surrogate key is the substitution of natural primary key

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


What is dimensional table? Explain the different dimensions.

0 Answers  






what is update strategy transformation ?

7 Answers   TCS,


I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,


please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,


What is repository manager?

0 Answers  


I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,


Why you use repository connectivity?

3 Answers   Yash Technologies,


What is the difference between stop and abort in informatica

0 Answers   Informatica,


Categories