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
- 11501 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 to do unit testing in informatica?
What is olap (on-line analytical processing?
What is standalone command task?
How to configure mapping in informatica?
What is update strategy transform?
Explain target update override in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How you prepared reports for OLAP?
What is domain and gateway node?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is union transformation in informatica?
What is the sequence generator transformation in informatica?
What are different types of transformations available in informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
