Re: ETL stuff, informatica

From: ddf <oratune_at_msn.com>
Date: Wed, 14 Aug 2013 08:26:59 -0700 (PDT)
Message-ID: <15c6ad8e-b001-4207-a097-69b0e2621d23_at_googlegroups.com>



On Tuesday, August 13, 2013 8:21:20 PM UTC-6, zigz..._at_yahoo.com wrote:
> On Thursday, August 24, 2006 11:44:53 PM UTC-4, soalva..._at_yahoo.com wrote:
>
> > 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
>
>
>
> If you search on google you can find lots of free videos on Informatica. I have used this tool in my work for 2 years extracting data from SAP into Oracle and sql server databases. I was lucky to get training on Power Center. Even after training, I found it was not easy to implement complex logic. I implemented lot of my logic in Oracle pl/sql stored procedures which I called from Informatica. This way I could take advantage of my Oracle skills as well as Informatica. Without Informatica, no way I could bring data from SAP because SAP programming requires knowledge of ABAP etc.. Why every big company has to create their own language!!!
>
> Good luck with Informatica.
>
>
>
> I also got to use SSIS, SQL Server Integration Services. SSIS is not limiited to SQL Server. It can connect to Oracle, Teradata and I think SAP (I have not tried that..). In some respects SSIS is better than Informatica and easier to learn. I learnt SSIS without any formal training.

Has anyone noticed this spammer is responding to a thread that's 8 years old?

David Fitzjarrell Received on Wed Aug 14 2013 - 17:26:59 CEST

Original text of this message