Identifying Dupilcate Reocords

[Kmcnally]

I have been placed on a project converion from World to OneWorld and we are being stopped by duplicate records.

Does anyone have any ideas on how to correctly idenify these records for deletetion?

 

[DBohner-(db)]

Howdy,

SQL the World Table - grouping by the Primary Keys 'as required' by the OW table. This will identify the duplicates in World - and those duplicates will have to be reconciled in World, FIRST. You don't want them to just go away - since the contain real data.

If the table is a co-existant table - I'd guess that a fix had never been applied to World (a logical that would have forced the correct keys). If that is the case - has their world implementation been plagued with issue or performance 'ickies' regarding the file?

Which file is the cryptler?

(db)

 

[Kmcnally]

Thank you for your input... Yes I have SQL the table and have found the Duplicate..now what is the best way to reconcile in world. one of the files is F43199.