Answer / ranjan

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

Answer / avinash kumar

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

Answer / mahendra reddy ongole

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

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.

Answer / tanmoy

A surrogate key is the substitution of natural primary key

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

which one is better performance wise joiner or look up

0 Answers   Informatica,

What aer the out put files that the informatica server creates during the session running?

4 Answers  

without using rank transformation how can we rank items by using some other transformations

2 Answers  

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

Explain lookup transformation source types in informatica

0 Answers   Informatica,

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

How can you complete unrcoverable sessions?

1 Answers  

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

HOW TO YOU LOAD TIME DIMENSION

1 Answers