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
- 11220 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivananda reddy
In informatica use this mapping
source->sqr->aggr->router->exp->target1
|
|->exp->target2
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / rajan raorane
You can use Router where One update strategy is directy
connected to Target table while other update strategy must
be followed by sorter with DISTINCT check which shud be
further connected to target table
This will differntiate Duplicate and non-duplicate records
in target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopi
For this i have seen one excellent video in YOUTUBE. Please
check this site.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Describe expression transformation?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
without matching columns in two tables. how can you join
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is aggregate cache in aggregator transformation?
What are the methods for creating reusable transforamtions?
Enterprise data warehouse your projects phase by phase explain?
Is there any way to read the ms excel datas directly into informatica?
What is difference between a connected look up and unconnected look up?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Teradata 
