Answer Posted / yaseen

sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.

And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update

Plz correct me if I am wrong

What is the maplet?

1202

---

What is the need for an etl tool?

1102

---

How we can create indexes after completing the load process?

1199

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

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?

1557

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2443

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1101

---

Which transformation is needed while using the Cobol sources as source definitions?

1219

---

can anyone explain me about retail domain project in informatica?

7998

---

What are the differences between a connected lookup and unconnected lookup?

1125

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1228

---

What is DR strategy for Informatica project?

1224

---

Tell me about Propagate functions in informatica

976

---

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?

1123

---

What is a repository manager?

1148

---