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

Home -> Community -> Usenet -> c.d.o.server -> Re: ETL stuff, informatica

Re: ETL stuff, informatica

From: Jim Kennedy <jim>
Date: Sat, 26 Aug 2006 17:24:32 -0700
Message-ID: <VqKdnclKPYUYeG3ZnZ2dnUVZ_s6dnZ2d@comcast.com>

<soalvajavab1_at_yahoo.com> wrote in message news:1156512811.569196.139070_at_h48g2000cwc.googlegroups.com...
> Thanks Jim, can you please at least tell me how:
>
> can I connect to repository as admin?

You bring up the repository manager logon as admin and the password.
>
> how can I see metadata?

There are views for that.

>
> what is maplet and what I can do with powercenter?
A mapping that can be reused in other places. Powercenter is their name for informatica.
>
> I really deeply appreciate your help
>
>
> Jim Kennedy wrote:
> > <soalvajavab1_at_yahoo.com> wrote in message
> > news:1156477492.996805.301320_at_74g2000cwt.googlegroups.com...
> > > Guys, I need your help for some stupid questions. We had an
> > > informatica/ETL guy in our team and he just left the company without
> > > notice for some reasons. I know Oracle and DBA stuff to some extend
but
> > > very newbie to ETL and informatica stuff we have.
> > >
> > > Can you direct me to:
> > >
> > > -- Informatica online help, forums, manuals?
> > >
> > > -- What is the main componets of informatica?
> > >
> > > -- Do you have any cheat sheet or snapshots as how I use informatica?
> > >
> > > --- How I basically start an informatca session?
> > >
> > > --- Can you give me one live example as how you really utilize
> > > informatica in your organization?
> > >
> > > I really appreciate your help
> > >
> > Informatica is an ETL tool. If you go to informatica.com you can access
the
> > online support if you have an account. We use it to extract financial
> > infomation out of SAP for our datawarehouse. There is online help
within
> > the application. I assume you have the client part installed on your
> > desktop? There are many pieces to informatica and while it isn't rocket
> > science to use it would be rather difficult to describe how exactly do a
> > whole slew of things. They do have a 3 or 4 day class and will even do
it
> > on site.
> > Jim
>
Received on Sat Aug 26 2006 - 19:24:32 CDT

Original text of this message

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