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
Explain the tuning lookup transformation - informatica
What are the types of data warehouses?
Explain sessions and how many types of sessions are there?
Scheduling properties,whats the default (sequential)
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Why update strategy and union transformations are active?
What is resilience time?
How do you load unique records into one target table and duplicate records into a different target table?
What is the status code in stored procedure transformation?
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
what are the deliverables?in your project?
What the difference is between a database, a data warehouse and a data mart?
Can we create multiple integration service on single repository?
Briefly explain the aggregator transformation?
What are the prerequisite tasks to achieve the session partition?