Answer Posted / venkatesh.malneni

here as the source meta data is same we can use UNION
t/r,after that i use AGGRIGATOR t/r in that i will count(no),
after that i will keep the filter t/r in that the condition
is count=0.then connect to the target
the result is as u want
the flow is as fallows

src--->sq--->union--->agg---->filter---->trg

What is session task and command task?

1299

---

Define joiner transformation?

1050

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

without table how to come first record only in oracle?

2256

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1505

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

---

What is rank transformation in informatica

1179

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1134

---

What is a surrogate key?

1083

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1065

---

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

1130

---

What are the different types of transformation available in informatica.

1105

---

How will the document be delivered to me?

1085

---

How do you change a non-reusable transformation to reusable transformation?

999

---

What is the use of target designer?

1055

---