Source-1
No name
1 satish
2 karthik
3 swathi
4 keerthi
Source-2
No name
1 satish
2 karthik
5 santhose
6 vasu
Target
3 swathi
4 keerthi
5 santhose
6 vasu here i want non matching
Records i want how to achieve that
- 5 Answers
- 6316 Views
- TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by pre and post session shell command?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to update a particular record in target with out running whole workflow?
what is song in infrmatica...?
What are the various types of transformation?
What is primary and backup node?
What is the use of an aggregator cache file?
What is substr in informatica?
Explain pushdown optimization and types in informatica
How to start a workflow using pmcmd command?
What happens when a session fails and you click on recover?
What is the need of an ETL tool?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How many dimensions are there in informatica?
