how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?

Answers were Sorted based on User's Feedback



how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / sivananda reddy

In informatica use this mapping

source->sqr->aggr->router->exp->target1
|
|->exp->target2

Is This Answer Correct ?    3 Yes 0 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

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

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

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

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

Answer / gopi

For this i have seen one excellent video in YOUTUBE. Please
check this site.

Is This Answer Correct ?    0 Yes 2 No

how can send duplicate records to one tableand non duplicate records to one table with simple clea..

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

Post New Answer

More Informatica Interview Questions

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,


What is the advantage of informatica?

0 Answers  


What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,


Define pmcmd command?

0 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  






what is unique constraint error ?

2 Answers   TCS,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


What is substr in informatica?

0 Answers  


Diffrence between static and dynamic cache

2 Answers   HCL,


. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  


How to update source definition?

0 Answers  


how to create a sample mapping for dynamic lookup transformation

2 Answers  


Categories