when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

Whats there in global repository

0 Answers  

---

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

update strategy transformation in informatica

0 Answers   Informatica,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---