how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 10353 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivananda reddy
In informatica use this mapping
source->sqr->aggr->router->exp->target1
|
|->exp->target2
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / roshan
hey u have to write a stored procedure to compare each record and then use a router T/R, if the record is non duplicated then it sends to one target and duplicated records to another target.. hope it works..
let me know if better option is available..
infernonag@gmail.com
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rajan raorane
You can use Router where One update strategy is directy
connected to Target table while other update strategy must
be followed by sorter with DISTINCT check which shud be
further connected to target table
This will differntiate Duplicate and non-duplicate records
in target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopi
For this i have seen one excellent video in YOUTUBE. Please
check this site.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Global and Local shortcuts. Advantages.
What are the types of error logs available in Informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
diffrence between command task and control task
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What are the designer tools for creating transformations?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What are the reusable transformations?
Teradata 
