Answer Posted / sushanth1234

Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.

What is resilience time?

1073

---

Briefly describe lookup transformation?

1001

---

What is sequence generator transformation in informatica?

1022

---

What is Index Caches size?

1075

---

What is Cognos script editor?

4182

---

What are the features of complex mapping?

1116

---

What is a connected transformation?

1068

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1238

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2041

---

what is the Default Source Option For Update Strategy Transformation?

1189

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997

---

Different sorts of metadata that stores in the storage facility?

972

---

Explain the aggregator transformation?

1109

---

What are the new features of informatica 9.x in developer level?

954

---

What are roles and groups and benefits of using them?

1014

---