Quality Manager/Data Validation

mihai · Post by **mihai** » Thu Mar 13, 2003 4:42 am

Hello

Depends on what kind of validation you require.

Quality Manager is a good tool, albeit pretty old now. Could you qualify what you mean by 'complete data validation'?

Kind regards,
Mihai

_________________________
desk direct:+441908448571

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2003 10:26 pm

There is a manual for Quality Manager on the CD. QM can audit your source system or your target system, but is limited in comparing data from disparate systems.

There is a fairly grey area between what QM does and what INTEGRITY does, though INTEGRITY does even more. For one thing, INTEGRITY has the capability to use rules to alter data into required format (this includes address cleansing). Since INTEGRITY is part of the DataStage XE Suite, maybe this will better suit your requirements.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

vijay · Post by **vijay** » Mon Mar 17, 2003 10:03 am

You can create a datastage ETL job and write the results to a target sequential file.

Hope this helps,
T.Vijay

vmcburney · Post by **vmcburney** » Mon Mar 17, 2003 5:13 pm

There are some tools out there that compare the contents of database tables. DBDiff is one example. I don't know which is the best tool in the market. They should be able to compare Access, Oracle and Sybase tables against each other. You may have to do some configuration due to different data types. I know with DBDiff if a particular column wont compare correctly you can remove it from the reports.

Vincent McBurney
Data Integration Services
www.intramatix.com