Answer / ranjan

Sql only allow us to join only two tables at a time because intersection/union methodology can only possible in two tables .

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

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,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

what is the difference between repository & Intergration service

1 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---