Re: Data conversion between various schemas

> There are newer data profiling products which not only integrate
multiple databases into a
> consolidated normalized model, they do so based on analyzing the data
below the metadata.
> Through inferring dependencies and redundancies across different
sources, the analyst can model
>the source data or map to a pre-defined fixed target.

Indeed there are tools to help automate the normalisation process on individual data sources (my step 2).
I'm not sure how well they work when attempting to integrate separate models together however. This is more a matter of matching entity predicates between sources rather than finding hidden functional dependences

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Jul 16 2002 - 20:06:46 CEST