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 / lokeah
SRC---union--agg---filter---tr
Here two SRC got same data typs n table structure so we can merge dem both
In agrr check group by to name col and add one extra col and named it cnt and condition is count(name) and pass prts to filter in filer write condition
Cnt=1....den we can get required op
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
can you please explain me pre session and post session options?
What are the reusable transformations?
what are the Methods For Creating Reusable Transformations?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the code page compatibility?
What is the function of look up transformation?
Explain lookup transformation source types in informatica
Separate from a database, an information bazaar, and an information stockroom?
Clarify the utilization of aggregator cache record?
Explain sql transformation in script mode examples in informatica
Write the prerequisite tasks to achieve the session partition?
Explain the informatica workflow?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Describe expression transformation?