471,072 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,072 software developers and data experts.

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 1276
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.