Compare IBM Datastage, Informatica and Microsoft SSIS

转载 2015年07月09日 16:29:09

1) System Plfatform

DataStage: Windows, Unix, Other Platforms
Informatica: Windows, Unix
Microsoft SSIS: Windows

2) Parallelism

DataStage:  Have both sequence (DataStage Server) and parallel (DataStage Enterprise Server )process
Informatica: ?
Microsoft SSIS: ?

3) Deployment facility

DataStage: No
Informatica: Yes
Microsoft SSIS: Yes

4) . Numbers of available transformation functions

Informatica:. 58
DataStage: 28 
Microsoft SSIS: 30

5) Slowly Changing Dimension

Informatica:. Supports Full history, recent values, Current & Prev values.
DataStage: Supports only through Custom scripts. Does not have a wizard to do this
Microsoft SSIS: Yes, with a Wizard but difficult to modify

6). Time Dimension generation

Informatica:. Does not support.
DataStage: Does not support
Microsoft SSIS: Does not support, but Time Dimension can be generated by using Microsoft SSAS

7). Rejected Records

Informatica:. Can be captured
DataStage: Cannot be captured in separate file
Microsoft SSIS: Can use conditional split transformation and error redirection to either CSV files or tables.

8). Debugging Facility

Informatica:. Not Supported
DataStage: Supports basic debugging facilities for testing.
Microsoft SSIS:  can use Breakpoint, Data Viewer and error handling

9) Application Integration Functionality, support for real Time Data Exchange

Informatica:. Not Available
DataStage: Not Available.
Microsoft SSIS: Not Available.

10) Metadata: Ability to view & navigate metadata on the web

Informatica:. Does not support
DataStage: Job sessions can be monitored using Informatica Classes
Microsoft SSIS: Does not support

11) Ability to Customize views of metadata for different users (DBA Vs Business user)

Informatica:. Supports.
DataStage: Not Available
Microsoft SSIS: Does not support 

12)  Metadata repository can be stored in RDBMS

Informatica:. Yes
DataStage: No. But the proprietary meta data can be moved to a RDBMS using the DOC Tool
Microsoft SSIS: Does not support 

13) Support And Maintenance, Command line operation

Informatica:. Pmcmd –server interface for command line
DataStage: Not Available
Microsoft SSIS:  Usage of Dtexec.exe

14) Ability to maintain versions of mappings

Informatica:. Yes
DataStage: No
Microsoft SSIS:  No

15) Job Controlling & Scheduling, Alerts like sending mails

Informatica:. Supported.
DataStage: Does not support directly ( no option). But possible to call custom programs after the job get executed)
Microsoft SSIS:  Job Agent, Email Notification

16) Languages

Informatica: ?
DataStage:  Script, C++
Microsoft SSIS:   C# (2005,2008), VB.NET (2005)

 17) ETL Proccess

Informatica: ?
DataStage:   DataStage Job
Microsoft SSIS:   package

18) Support for looping the source row (For While Loop)

Informatica:. Supports for comparing immediate previous record
DataStage: Does not support
Microsoft SSIS: Yes. ForEach Loop

举报

相关文章推荐

What Microsoft, Oracle, IBM, And SAP Don't Tell Customers

Share The four big software vendors -- Microsoft, Oracle, IBM, and SAP -- have hidden...

IBM InfoSphere DataStage 实时监控和统一运维平台

IBM InfoSphere DataStage Operations Console 是一个基于 Web 的监视工具。它为 InfoSphere DataStage 和 QualityStage 客...

我是如何成为一名python大咖的?

人生苦短,都说必须python,那么我分享下我是如何从小白成为Python资深开发者的吧。2014年我大学刚毕业..

IBM管网DataStage数据整合学习参考地址

IBM管网DataStage数据整合学习参考地址

datastage(IBM InfoSphere Information Server )日志的获取和分析

在使用 IBM InfoSphere Information Server 的过程中我们经常会遇到一些问题,但如何来查找和诊断问题,对于一个刚刚使用 IBM InfoSphere Informat...

分析IBM datastage job 构建过程

在IBM datastage job 中我们知道共有三种类型,在此简单阐述下 1.server job ,运行在server 服务器端,简单用于逻辑控制的job 可以采用这种方法实现 2.para...

datastage8.7 Microsoft Windows 脚本编制引擎必须正常工作。

1.安装datastage8.7客户端遇到这个奇葩的问题 datastage8.7 Microsoft Windows 脚本编制引擎必须正常工作。 2.在自己本机重新建一个例如:xxx.reg注册...

WIN7安装Datastage 8.5检查环境报错:Microsoft Windows Script Engine 必须正常工作

http://blog.csdn.net/pangdingshan/article/details/7170875   工作需要,在WIN7安装datastage 8.5客户端的时候,遇到问题:检...
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)