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 cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

Mention few power centre client applications with their basic purpose?

1 Answers  

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

How do you remove duplicate records in informatica?

1 Answers  

---

How to update source definition?

1 Answers  

---

what is data driven?

1 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

What are the guidelines to be followed while using union transformation?

1 Answers   Informatica,

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1 Answers  

---

How we can create indexes after completing the loan process?

1 Answers  

---