Thanks everyone for the information! I have found a couple even
though they may not be "free".

1. Data Quality / Explorer by Informatica
2. Oracle Warehouse Builder
3. IBM WebSphere Information Analyzer
4. Pervasive Data Profiler

Wonder if anyone has any comments, pro and/or cons about these
products.

Thanks in advance!

N.

On Jun 22, 2:45 pm, goog <ning.... (AT) dfa (DOT) state.ny.us> wrote:
BTW, we are in the process of migrating data to Oracle - just to make
things
clear as of what I am trying to do here. Thanks.

N.

As primary role of data analyst (doing data migration) I have to do
this on almost every but of data I receive and upload to a new
database.
The best thing to do is probably write your own packages and
procedures that exactly match your requirements.