Answer / snu

A single global repository and any number of local
repositories.

Answer / jagan

unlimited repositories

Answer / nagaraj.g

we can create 200 repositories in informatica

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

How we can create indexes after completing the load process?

0 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

How to differentiate between the active and passive transformations?

0 Answers  

---

what are the types of facts with Examples?

3 Answers  

---

What are the active and passive transforamtions?

2 Answers  

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---