Answer Posted / anoymous

override source qualifier

select * from tablename where rownum=1 and rownum=10;

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2130

---

Explain the different lookup methods used in informatica?

1038

---

Explain your project of banking domian.

1650

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2178

---

Which transformation is needed while using the Cobol sources as source definitions?

1167

---

What will be the approach?

977

---

What does role playing dimension mean?

1044

---

differences between service based and product based?

2010

---

How to do unit testing in informatica? How to load data in informatica ?

1119

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1951

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1577

---

Can we override a native sql query within informatica?

1034

---

What are the features of complex mapping?

1152

---

What is difference between a gateway node and worker node?

1134

---

What is an Integration service in Informatica?

1129

---