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
- 7716 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
can u give example for factless fact table
What are the different versions of informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to start a workflow using pmcmd command?
Whats there in global repository
Explain lookup transformation in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to handle decimal places while importing a flatfile into informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
what is index?how it can work in informatica
How many dimensions are there in informatica?
What are the differences between oltp and olap?
what is unit testing?tell me proceedure
what is degenerated dimension?
How you know when to use a static cache and dynamic cache in lookup transformation?
