here as the source meta data is same we can use UNION t/r,after that i use

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

Question Posted / venkatesh.malneni

5 Answers
7848 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

Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

995

How to generate sequence numbers using expression transformation?

1074

What is the fact table?

1050

What is a joiner transformation?

970

How to differentiate between the active and passive transformations?

1139

Clarify the aggregator change?

1013

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1089

What is decode in informatica?

1123

How does a sorter cache works?

1045

How do you manage the Parameter files while migrating your data from one environment to another environment?

999

What do you mean by filter transformation?

938

Explain sessions and how many types of sessions are there?

988

What is the format of informatica objects in a repository?

1009

Mention some types of transformation?

1031

What do you mean incremental aggregation?

1055