Validating 2 data sources using QVDs

[tinkerz1]

Hi,

I have been given 2 QVD's to compare, both QVDs have the same field names, the reason for the check is one is from an Access data base and the other is has been ported from Access to SQL.

That is why I need the check.

I am thinking to join fields in a hash function by groups of fields,ie Hash(FieldA&FieldB&FieldC)

Then compare in Excel, before I start does anyone have a better solution.

Thanks

Neil.

[adityaakshaya]

Hi Neil,

Using Hash function is a good Idea.

You can pull the data from different sources, Join them, create two hash map fields (one from Access and one from SQL), compare and flag there only if they are not matching. Using the flag, you can able to identify if there is a data change.

You don't need to pull out data in excel to validate.

Hope this helps you.

Regards,

Akshaya