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

what is semi-additive fact?where did u used?

2 Answers  

What is mapping debugger?

0 Answers  

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

What is an expression transformation in informatica?

0 Answers  

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

How big was your fact table

0 Answers  

in which situations do u go for starflake schema ?

6 Answers   TCS,

What is meant by lookup transformation?

0 Answers  

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,