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
- 11227 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
What do mean by local and global repository?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain direct and indirect flat file loading (source file type) - informatica
tell me about your project functionality
What are the guidelines to be followed while using union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain sessions and how many types of sessions are there?
What is meant by lookup transformation? Explain the types of lookup transformation?
Parameter and variable differences
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the advantage of informatica?
What is informatica? Why do we need it?
Explain the aggregator transformation?
