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
- 7919 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
How to open an older version of an object in the workspace?
Where do we use mapping variables in informatica?
Performance tuning in UNIX for informatica mappings?
What are the various types of transformation?
how to load rows into fact table in data warehouse
What is the difference between a connected look up and unconnected lookup?
What are active transformations.
According to his methodology what all you need before you build a datawarehouse
What are session parameters ? How do you set them?
What is sq transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is flashback table ? Advance thanks
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the prerequisite tasks to achieve the session partition?
Differentiate between a database and data warehouse?
