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 / ganga

Hi Davankumar,


once find the sources1 & 2 here both tables structures same
but some records are diff so i wanna find which columns are
diff

both tables contain 1,2 records but some records are diff
means 3,4,5,6 how to retrieve these to your target in
informatica level

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the tuning lookup transformation - informatica

1047


What are the types of data warehouses?

1577


Explain sessions and how many types of sessions are there?

1060


Scheduling properties,whats the default (sequential)

2014


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1848


Why update strategy and union transformations are active?

1098


What is resilience time?

1227


How do you load unique records into one target table and duplicate records into a different target table?

1320


What is the status code in stored procedure transformation?

1234


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2293


what are the deliverables?in your project?

2197


What the difference is between a database, a data warehouse and a data mart?

1202


Can we create multiple integration service on single repository?

1242


Briefly explain the aggregator transformation?

1068


What are the prerequisite tasks to achieve the session partition?

1297