SEO

#1 (**permalink**) 02-29-2008, 06:42 PM

Can anyone please point me to a study comparing SQL 2005's integration
services with Ascential, specifically for the tasks of (a) matching
records about residential properties and transactions (typically
described in terms of address, owner name, parcel number and legal
description -- which may not be accurate or complete; a given
transaction may appear in several feeds), and (b) creating composite
records from matched sets. In Ascential, (a) is called "Quality Stage"
and (b) "Data Stage".

Thanks,
Jim Geissman

#2 (**permalink**) 02-29-2008, 06:42 PM

jim_geissman@countrywide.com wrote:
> Can anyone please point me to a study comparing SQL 2005's integration
> services with Ascential, specifically for the tasks of (a) matching
> records about residential properties and transactions (typically
> described in terms of address, owner name, parcel number and legal
> description -- which may not be accurate or complete; a given
> transaction may appear in several feeds), and (b) creating composite
> records from matched sets. In Ascential, (a) is called "Quality Stage"
> and (b) "Data Stage".
>
> Thanks,
> Jim Geissman

Haven't seen any specific comparisons. This article may be relevant:
http://msdn.microsoft.com/msdnmag/is...SQLServer2005/

Note that Ascential is no longer Ascential. DataStage is now part of
IBM's WebSphere line-up:
http://www-306.ibm.com/software/data...ion/datastage/

SSIS home:
http://www.microsoft.com/sql/technol...n/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL Server 2005 vs Ascential