Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 7846 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
here as the source meta data is same we can use UNION
t/r,after that i use AGGRIGATOR t/r in that i will count(no),
after that i will keep the filter t/r in that the condition
is count=0.then connect to the target
the result is as u want
the flow is as fallows
src--->sq--->union--->agg---->filter---->trg
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / davankumar
ur qus is diffrent but ans is...u r ans non_duplicate
records into taget.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / 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 |
Answer / kumarapillaietl@gmail.com
Create union tr , send all ports from two sources ,create sorter tr after union sort port asc in column no.
And send this ports into new exp tr here create 3 variable port one output port.
V_curr_no=id------>no.
V_count=iif(v_curr_no=v_pre_no,v_count+1,1)
V_pre_no=I'd
O_count=v_count
After done exp tr
Pass all ports from exp to filter
Condition like o_count=1
Get all non_match records .then pass into tgt .
Happy thank yoy
| Is This Answer Correct ? | 0 Yes | 0 No |
tell me 7.x and 8.x diferrencess(but not transformations)
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
What is workflow? What are the components of workflow manager?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What will be the approach?
When do you use sql override in a lookup transformation?
can u any challenge your project?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Explain incremental aggregation in informatica
What are the transformations that are not supported in mapplet?
What is the difference between Normal load and Bulk load?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Teradata 
