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
6336 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

Explain the different lookup methods used in informatica?

599

Briefly define a session task?

599

What is pmcmd command?

685

Why update strategy and union transformations are active? Explain with examples.

722

Explain the scenario which compels informatica server to reject files?

665

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1061

what is song in infrmatica...?

1695

What are the new features of informatica 9.x in developer level?

570

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

681

COM components can be used in Informatica

1884

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

639

How to update source definition?

643

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5274

How can we use mapping variables in informatica? Where do we use them?

630

Enlist some properties of sessions.

640