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 components of the workflow manager?
how tokens will generate?
What is pmcmd command?
Which are the different editions of informatica powercenter that are available?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can you use flat files in Mapplets.
define galaxy repository in informatica
How you can differentiate between connected lookup and unconnected lookup?
What is the difference between informatica 7.0 and 8.0?
What is the difference between informatics 7x and 8x and what is latest version?
What is standalone command task?
What is mapplet in informatica?
Write the program through which the records can be updated?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
In informatics server which files are created during the session rums?