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

define galaxy repository in informatica

0 Answers  


What does update strategy mean, and what are the different option of it?

0 Answers  


LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  


what is the function of 'F10' informatica ?

4 Answers   IBM,


What are the phases in SDLC?

3 Answers  






i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  


What is Data Caches size?

0 Answers   Informatica,


What is sequence generator transformation in informatica?

0 Answers  


What do you mean by worklet?

0 Answers  


Can anyone briefly describe abt audit table loading?

2 Answers   TCS,


what is diff between grep and find

3 Answers   IBM, iFlex,


Categories