I do not know your background, congratulations if you
were able to develop performant mappings. But it's not
the case on most clients I've seen where average
developper were developping with the ETL tool.
I'm sure that an experienced DBA with a good knowledge
of its working environnement and who has always
performance, ease of maintenance and robustness in his
mind, could develop good mappings.
In the real life, the development is done by people
with a medium knowledge of SQL, a weak knowledge of
tuning and the rdbms and with 3-4 years of experience.
Stephane
- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> a écrit :
> Actually I do not know what is hard about learning
> Informatica or Sagent!
>
> In my opinion it's a toy.
>
> It's very easy and nothing is difficult to learn.
>
> Sagent is more intuitive than Informatica but
> Informatica engine might be
> more stable.
>
> Regards,
>
> Waleed
>
> -----Original Message-----
> Sent: Friday, July 06, 2001 5:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> We're currently using Powermart. I'm not developping
> the mappings but I'm checking what the developpers
> are
> doing. I've used Sagent tool a little bit and at a
> client we've developped the ETL tool ourselves.
>
> Powermart is not an easy tool to learn.
>
> At my request, we finally have an Informatica
> consultant in house to look at what we've done so
> far
> (yesterday and today). Like all tools, you can do
> things by yourself but you can't achieve performance
> without an expert.
>
> There are things you want to do in Oracle and not in
> the ETL tool so you have some choices to do. I like
> to
> put some intellingence in the metadata and have the
> programs to act accordingly to what the metadata
> contains. The developpers could not figure out how
> to
> do this, the Informatica consultant will show us
> that
> this afternoon.
>
> So bottom-line, it is not an easy tool to learn.
>
>
> Also, you really need a 21 inches screen to work
> with
> Powermart.
>
> Stephane
>
> --- Larry Elkins <elkinsl_at_flash.net> a écrit : >
> Listers,
> >
> > For any of you who use Informatica ETL products
> such
> > as PowerMart and/or
> > PowerCenter, how steep is the learning curve for
> > these products? I know
> > there are lots of variables such as how quickly
> does
> > the person pick up new
> > things, are we talking about learning the basics
> and
> > doing simple tasks, or,
> > doing advanced things, etc. For example, with some
> > products, one can quickly
> > learn to perform basic functions, but, there can
> be
> > a steep learning curve
> > to perform advanced functions.
> >
> > Just curious about the complexity and
> > ease/difficulty of getting up to speed
> > on these tools.
> >
> > Regards,
> >
> > Larry G. Elkins
> > elkinsl_at_flash.net
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Larry Elkins
> > INET: elkinsl_at_flash.net
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
>
> Do You Yahoo!? -- Pour faire vos courses sur le Net,
>
> Yahoo! Shopping : http://fr.shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping :
http://fr.shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 06 2001 - 09:30:29 CDT