Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Rants. Difficulty to learn ETL tools?

Re: Rants. Difficulty to learn ETL tools?

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Wed, 18 Apr 2007 20:58:52 +0100
Message-ID: <newscache$d3mpgj$n7a$1@newsfront4.netvisao.pt>


Hi,
even Oracle have some GUI tools :P

Have you take a look at Oracle Warehouse Builder (I think this one is free now) or the new Oracle Data Integrator (ex: Sunopsis)?

pedro.

dba_222_at_yahoo.com wrote:
> Dear Experts,
>
> I've worked with Oracle since 1995. I have gone
> very deep into many of the Oracle features, including
> sqlloader, and export/import. And I've done data
> modelling even longer.
>
>
> At the same time, I have done ETL since 1995.
> Although, at the Proc, and PLSQL, sqlloader, level.
> Map the data. Take data from the source, do any
> modifications/transformations that are required,
> and insert or update. Easy. The hard part is
> determining the mappings.
>
>
> But I have not been given the opportunity to
> work much with ETL tools such as:
> Informatica, DataStage, Ascential, Ab Initio
>
> The little bit of experience that I do have,
> showed that Informatica was -incredibly- easy to use.
> It's a GUI. It's SUPPOSED to be simple!!!
>
>
> I have missed out on a number of opportunities
> because I didn't have a few YEARS of experience
> with ETL tools. Which seems odd, because the
> tool looks like it requires a max of a week to learn!
>
>
> Just how difficult are these ETL tools to learn?
> Especially if you have already been working with
> Oracle, and doing data mappings and loads since 1995?
> I'm thinking that it can't be difficult at all.
>
> When you search for newsgroups, there are no newsgroups
> for these tools. Although the companies who make
> them, might have their own newsgroup.
>
>
> There are also not many books on these tools.
> If you search for books on Oracle, or SQL Server,
> you will find a lot of very big, and detailed
> books. But there is next to nothing specifically
> on the various ETL tools.
>
> Any certifications for any of these tools look
> to be much simpler than Oracle's.
>
>
> To me, the real issue is the mappings. If you
> come into a new environment, the data mappings
> are completely esoteric to those systems.
> No amount of experience with an ETL tool, or any
> tool, is going to tell you what the mappings should be.
>
>
> Questions:
> - Just how difficult are these ETL tools to learn
> for an experience Oracle pro like myself?
>
> - Other than a GUI, making everything simple to use,
> just what are the advantages of using ETL tools?
>
> - what built in functionality do ETL tools
> have, that can't be done in PLSQL?
>
>
> Thanks a lot!
>
Received on Wed Apr 18 2007 - 14:58:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US