Answer Posted / srinivas

dataflow

FF-----> Sourcequalifier...>aggregatore T/F....>target

in aggregator transformation add three new ports
o_col1,0_col2,o_col2 and make output ports
and expression in out ports
o_col1-----MAX(col1),
o_col2-----Max(col2),
o_col3-----Max(col3);
and connect these output ports to target
you will get the resul

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

2091

---

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?

1493

---

Slowly changing dimensions, types and where will you use them

1691

---

What are the data movement modes in informatica?

1134

---

How can you define user defied event?

1013

---

How can you increase the performance in joiner transformation?

1181

---

In how many ways we can create ports?

1108

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1174

---

What is the use of transformation?

983

---

What is the fact table?

1050

---

Different sorts of metadata that stores in the storage facility?

995

---

How to create the source and target database connections in server manager?

1071

---

How to do the error handling of if ur source is flatfiles?

1948

---

What are the advantages of informatica?

997

---

What is the way to execute pl/sql script using informatica mapping?

1583

---