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
- 11469 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 do you use reject loader.
Clarify the utilization of aggregator cache record?
What is a surrogate key?
What is a mapplet/worklet in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How an expression transformation differs from aggregator transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is xml source qualifier transformation in informatica?
expain about the tune parameters?
What are the limitations of joiner transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Differentiate between a repository server and a powerhouse?
where to store informatica rejected data? How to extract the informatica rejected data?
How do you load alternate records into different tables through mapping flow?
How can we handle two sessions in informatica?
