Answer Posted / vivekk

Src-->SQ-->AGG-->RTR--->TG1 & TG2

In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.

wf dont have integration severances how you can run?

1887

---

How to generate sequence numbers without using the sequence generator transformation?

1116

---

What is informatica metadata and where is it stored?

935

---

What is InformaticaPowerCenter?

1077

---

What is the session task and command task?

995

---

How we can create indexes after completing the load process?

1114

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1578

---

Mention a few design and development best practices for informatica?

937

---

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.

1224

---

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

987

---

What is meant by a domain?

1081

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2102

---

can anyone explain me about retail domain project in informatica?

7892

---

How can we use mapping variables in informatica? Where do we use them?

1101

---

Explain how many types of dimensions are available in informatica?

1010

---