Re: ETL stuff, informatica
Date: Tue, 13 Aug 2013 19:21:20 -0700 (PDT)
Message-ID: <4df3d078-e6bb-4a6e-93b9-159bb0fe7e01_at_googlegroups.com>
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. Received on Wed Aug 14 2013 - 04:21:20 CEST