Answer Posted / kumarapillaietl@gmail.com

Create union tr , send all ports from two sources ,create sorter tr after union sort port asc in column no.
And send this ports into new exp tr here create 3 variable port one output port.
V_curr_no=id------>no.
V_count=iif(v_curr_no=v_pre_no,v_count+1,1)
V_pre_no=I'd
O_count=v_count
After done exp tr
Pass all ports from exp to filter
Condition like o_count=1
Get all non_match records .then pass into tgt .

Happy thank yoy

What is a joiner transformation and why it is an active one?

1057

---

define galaxy repository in informatica

2203

---

What does reusable transformation mean?

1116

---

Explain joiner transformation in informatica

1105

---

What is an Integration service in Informatica?

1116

---

What is dimensional table? Explain the different dimensions.

1155

---

what is diff b/t sorter t/r and agg have the option sorter property...

2157

---

tell me the rules and responsblites in our project(my project is development)

1915

---

Explain your project of banking domian.

1639

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1159

---

Please let me know how to make Data masking in informatica..

1695

---

What do you mean by filter transformation?

938

---

How to create or import flat file definition in to the warehouse designer?

1055

---

Enlist the tasks for which source qualifier transformation is used.

1022

---

What is fact table? Explain the different kinds of facts.

1059

---