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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is Data Caches size?
How can repository reports be accessed without sql or other transformations?
What are the tasks that can be performed using sq?
scenario where i can use only concurrent execution of workflow.
How can informatica be used for an organization?
What are mapplets?
what is the size of your data warehousing?
What is the benefit of session partitioning?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the difference between a repository server and a powerhouse?
What is a mapplet/worklet in informatica?
What do mean by local and global repository?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?