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
- 11476 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 |
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the uses of a Parameter file?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
Define enterprise data warehousing?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is Datadriven?
how we do performence tuning in informatica
What do you mean by channel change?
what is the difference between onsite & client site?
In any project how many mappings they will use(minimum)?
Teradata 
