Interested to Buy Any Domain ? << Click Here >> for more details...
how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 11664 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 |
Is it possible to revert a global repository to local one and why?
Enlist the advantages of informatica.
My source table having some records ,i want load 1st record and last record into one target?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Which kind of index is preferred in DWH?
Can we update the data in flat file using update strategy?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
In which circumstances that informatica server creates Reject files?
Explain sessions. Explain how batches are used to combine executions?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
what are the limitation of sorter transformation?
Teradata 
