Page 1 of 1
Posted: Thu Mar 13, 2003 4:42 am
by mihai
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
Posted: Thu Mar 13, 2003 10:26 pm
by ray.wurlod
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
Posted: Mon Mar 17, 2003 10:03 am
by vijay
You can create a datastage ETL job and write the results to a target sequential file.
Hope this helps,
T.Vijay
Posted: Mon Mar 17, 2003 5:13 pm
by vmcburney
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