Answer Posted / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

---

Explain load alternative records / rows into multiple targets - informatica

1102

---

How many ways are there to do 'remove duplicate records in informatica'?

956

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1052

---

Describe the impact of several join conditions and join order in a joiner transformation?

1009

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1061

---

How can we delete duplicate rows from flat files?

1165

---

How do you take back up of repository?

1094

---

Explain transaction control transformation in informatica

1213

---

How would you join a node to the already existing domain?

1068

---

What are the new features of Power Center 5.0?

1701

---

server hot-ws270 is connect to Repository B. What does it mean?

2442

---

What are the advantages of informatica?

959

---

How to Create a folder using pmrep command?

1107

---

What is data movement mode in Informatica and difference between them?

1066

---