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
- 11454 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is meant by active and passive transformation?
How does a sorter cache works?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to elaborate tracing level?
What are the transformations that are not supported in mapplet?
What is aggregator transformation in informatica?
What is the advantage of informatica?
Does an informatica transformation support only aggregate expressions?
can anyone suggest best free Talend data integration training online
On which transformations you created partitions in your project?
What do mean by local and global repository?
can we override a native sql query within informatica? Where do we do it?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
