how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
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
What is a surrogate key?
In informatics server which files are created during the session rums?
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
Differentiate between source qualifier and filter transformation?
What are the features of complex mapping?
How are indexes created after completing the load process?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How can a transformation be made reusable?
Implementation methodology
What is the different lookup cache(s)?
where to store informatica rejected data?
What are batches?
Describe expression transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain pushdown optimization $pushdownconfig parameter - informatica