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
What are the settings that you use to configure the joiner transformation?
What are different types of transformations available in informatica?
How can we use mapping variables in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Define mapping and session?
What is persistent lookup cache?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How we can create indexes after completing the loan process?
How to update or delete the rows in a target, which do not have key fields?
Differentiate between sessions and batches?
How does a rank transform differ from aggregator transform functions max and min?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How can informatica be used for an organization?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
While importing the relational source definition from the database, what are the metadata of source that will be imported?