468,161 Members | 2,019 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,161 developers. It's quick & easy.

SQL Server 2005 vs Ascential

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

Mar 14 '06 #1
1 1205
ji**********@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
--

Mar 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by RdR | last post: by
17 posts views Thread by Danieltbt05 | last post: by
10 posts views Thread by amjad | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.