Routing duplicate records

[mailtos.ravi]

I have a situation here where we r having duplicate records in my source we need to route distinct records to one target and all duplicate records need to routed to another target? can any body explain how is this possible?

[gottipalli]

Hi,

Use router transformation to route the duplicate data to one target and distinct rows to another target.

in one router transformation use the condition row_number>1