Answer Posted / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

What does reusable transformation mean?

1068

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2073

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1925

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2206

---

What is aggregator transformation in informatica?

895

---

Explain constraint based loading in informatica

1036

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1441

---

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?

998

---

Explain the mapping variable usage example in informatica

1080

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1841

---

update strategy transformation in informatica

1013

---

What is a node in Informatica?

1002

---

How to configure mapping in informatica?

1118

---

What are pre and post-session shell commands?

1235

---

Why sorter is an active transformation?

1130

---