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 the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

Explain about Informatica server process that how it works relates to mapping variables?

1128

---

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

1081

---

Explain the use of aggregator cache file?

1319

---

What are the different ways to implement parallel processing in informatica?

1483

---

What will be the approach?

1039

---

How you can differentiate between connected lookup and unconnected lookup?

1107

---

What is rank transform?

1061

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9901

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7591

---

Can we get 1st record through Informatica(without sequence number).

1521

---

How to handle decimal places while importing a flatfile into informatica?

1242

---

Enterprise data warehouse your projects phase by phase explain?

1969

---

What are the tasks that can be performed using sq?

1144

---

r u done any partitions in ur project?

1867

---