Answer Posted / deepika

In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns mutiple matched ports.

What are the types of schemas we have in data warehouse.

1004

---

What are junk dimensions?

1111

---

can u any challenge your project?

2083

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2151

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1334

---

what is diff b/t sorter t/r and agg have the option sorter property...

2230

---

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?

2071

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

Difference between Target-based loading and constraint-based loading?

1042

---

What is joiner transformation in informatica?

1098

---

What is a connected transformation?

1183

---

What is the difference between a connected look up and unconnected lookup?

1000

---

Explain pushdown optimization and types in informatica

1122

---

What is lookup change?

1108

---

What is option by which we can run all the sessions in a batch simultaneously?

1189

---