SQL Server SSIS and Oracle Data Pump

Question

I'm a beginner, and trying to improve my knowledge on DB side.

I am learning SSIS with SQL Server 2008R2. Going by the tutorials from Web, I feel like this is somewhat similar to what I've read about Oracle Data Pump.

Can someone enlighten me, if there is similarity between two SSIS and Data Pump. If they are totally different, please forgive me for this question. Else, let me know how they are similar.

Regards, Justin

Answer 1

Data Pump is not a complete ETL tool,it is a feature in Oracle 11g.It transfers the data from a single file to a single destination.With SSIs you got all the extraction ,transformation and loading facilities.

Corresponding to SSIS ,oracle has oracle warehouse builder.

Oracle data pump is an alternative to EXPORT and Import utility in SQL SERVER.