Answer Posted / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1052

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7365

---

Briefly define a session task?

1109

---

What is a passive transformation?

1083

---

How can we handle two sessions in informatica?

1021

---

Implementation methodology

1696

---

If informatica has its scheduler why using third party scheduler?

1249

---

What is joiner change?

1138

---

How to join three sources using joiner? Explain though mapping flow.

1133

---

Tell me about Propagate functions in informatica

915

---

How does the aggregator transformation handle null values?

1134

---

can we override a native sql query within informatica? How do we do it?

1106

---

What is powercenter on grid?

1168

---

What is DR strategy for Informatica project?

1159

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2086

---