Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / lokeah

SRC---union--agg---filter---tr
Here two SRC got same data typs n table structure so we can merge dem both
In agrr check group by to name col and add one extra col and named it cnt and condition is count(name) and pass prts to filter in filer write condition
Cnt=1....den we can get required op

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1036


can you please explain me pre session and post session options?

7407


What are the reusable transformations?

1099


what are the Methods For Creating Reusable Transformations?

1102


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1017


Explain the code page compatibility?

1022


What is the function of look up transformation?

1058


Explain lookup transformation source types in informatica

1043


Separate from a database, an information bazaar, and an information stockroom?

1015


Clarify the utilization of aggregator cache record?

945


Explain sql transformation in script mode examples in informatica

1048


Write the prerequisite tasks to achieve the session partition?

1075


Explain the informatica workflow?

1006


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2317


Describe expression transformation?

1045