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

What is parallel processing in informatica?

1795


tell me 5 session failure in real time how can you solve that in your project?

2393


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123


Clarify the aggregator change?

1081


Briefly define a session task?

1197


what is the hint? how to use it to reduce the query processing in program?

7982


What is a predefined event?

1137


Explain constraint based loading in informatica

1157


How can you validate all mappings in the repository simultaneously?

1427


Explain in detail about scd type 1 through mapping.

1630


What is lookup change?

1111


Explain what is informatica metadata and where is it stored?

1110


What is data transformation manager process?

1222


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2049


During the running session, output files are created by informatica server. Enlist few of them.

1022