http://snipplr.com/language/plsql/tags/etl Recent snippets posted on Snipplr.com en-us Wed, 19 Jun 2013 06:57:55 GMT http://snipplr.com/view/56332/strategy-to-identify-duplicates-in-an-etl-context-for-example/ This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

]]> Sat, 09 Jul 2011 00:21:15 GMT http://snipplr.com/view/56332/strategy-to-identify-duplicates-in-an-etl-context-for-example/