hi
We are having data quality issues. Making evaluations between Quality stage or Evoke.
Does Quality stage support only flat file inputs for matching or standardisation?
Thanks
relational DB as source for qualitystage?
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
QualityStage on it's own only reads flat files. You will need to write your RDBMS data out to flat files. The QualityStage plugin for DataStage lets you feed any DataStage plugin data source into a QualityStage job where DataStage formats it into a fixed width format that QualityStage can handle. This removes the need to save the data to a flat file.
I wouldn't be comparing QualityStage to Evoke, far more appropriate to compare Evoke to ProfileStage/AuditStage and Discovery and to compare QualityStage to other quality cleansing products. From what I know of Evoke it does not correct problems, it only performs profiling.
I wouldn't be comparing QualityStage to Evoke, far more appropriate to compare Evoke to ProfileStage/AuditStage and Discovery and to compare QualityStage to other quality cleansing products. From what I know of Evoke it does not correct problems, it only performs profiling.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Re: relational DB as source for qualitystage?
We've been passing data to QualityStage from Sybase via an ODBC connection (although getting it working for our server set up took us a while). From the manuals, ODBC connections are fairly standard, and remove the need for a lot of file creation and even file definition.
(Writing back from QualityStage to Sybase had its own hassles, but we've managed that as well.)
Cheers,
Jamas
(Writing back from QualityStage to Sybase had its own hassles, but we've managed that as well.)
Cheers,
Jamas