Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7906 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 a standalone command task?
what is the difference between informatica6.1 and infomatica7.1
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the session task and command task?
What is lookup transformation?
What is the reusable transformation?
What are the differences between a connected lookup and unconnected lookup?
What is a joiner transformation and why it is an active one?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is rank transformation in informatica
What is a sorter transformation?
Slowly changing dimensions, types and where will you use them
Why filter transformation is an active one?
list out all the transformations which use cache?
What are multi-group transformations?
