New discussion topic on DataCleaner's online discussion forum (https://datacleaner.org/forum):
David Doyle posted the subject 'Comparing Source to Target' ------------------- Is it possible to use data cleaner to compare a source/master db to a target db/ copy which uses a different structure? Both source and target use differently normalized structures but share some common keys albeit in different formats (numeric customer# vs a varchar customer#). While I could use a regular ETL tool to do this, tooling more focused on DQ metrics would be preferred as I'd like to take matched records and then compare on a field-by-field basis to determine missing & invalid values. Ultimately I'd like to create a periodic scorecard and monitor over time. Looking through the site there doesnt seem to be much in the way of examples/ success stores on the usage of the tooling (unless I'm lookng in the wrong area of the site) hence my question. ------------------- View the topic online to reply - go to https://datacleaner.org/topic/1460/Comparing-Source-to-Target -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
