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
- 7715 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venkatesh.malneni
here as the source meta data is same we can use UNION
t/r,after that i use AGGRIGATOR t/r in that i will count(no),
after that i will keep the filter t/r in that the condition
is count=0.then connect to the target
the result is as u want
the flow is as fallows
src--->sq--->union--->agg---->filter---->trg
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
How to handle decimal places while importing a flatfile into informatica?
What do you mean by channel change?
Define enterprise data warehousing?
What is the difference between source qualifier transformations source filter to filter transformation?
What is rank transform?
If informatica has its scheduler why using third party scheduler?
What are multi-group transformations?
Under what condition selecting sorted input in aggregator may fail the session?
r u done any partitions in ur project?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is informatica?
What are the reusable transformations?
Name the different lookup cache(s)?
Write the unconnected lookup syntax and how to return more than one column.
