Re: free oracle data profiling/quality tool

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 20 Jun 2007 13:05:29 -0500
Message-ID: <4679602d$0$25520$88260bb3@free.teranews.com>

goog wrote:

> On Jun 20, 10:51 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:

>> On Jun 19, 2:43 pm, goog <ning...._at_dfa.state.ny.us> wrote:
>>
>>> Hi,
>>> I am in search of a downloadable oracle data profiling/quality tool.
>>> Any recommendation is highly appreciated. Thanks!
>> Can you give us some examples of existing commercial products that
>> currently exist?
>>
>> What are you thinking of exactly?
>>
>> You can always develop sql scripts and kick them off via sqlplus.
>> Once you have a script that fits your purpose that's in sql or plsql
>> it can be used ( with version dependencies of course ) by everyone.

> 
> Like Oracle Discoverer.  The idea is to analyze the data and verify
> that the data conforms the
> column definition (data type, length, etc) and other constraints, etc.
> 

The data will always conform to the column definition and other constraints. If the data does not conform to the column definition or constraint, then an error will be raised for the DML statement attempting to populate the column.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Wed Jun 20 2007 - 13:05:29 CDT