I need some information about the Informatica ETL tool. I am a rookie with that, so could you please recommend where can I get some tutorials to get started. Can I download the tool, and if so where can I download it? What are the alternatives to Informatica?
RTFM: http://en.wikipedia.org/wiki/Informatica
Can I download the tool - Its a commercial app, you need to buy it.
where can I get some tutorials to get started - http://www.google.com/search?q=informatica+tutorials
What are the alternatives to Informatica? - Can't say, There are at least 10 products of Informatica.
For everything else, Google is your friend.
Informatica is one of many ETL tools. Ab Initio and SSIS are commercial competitors; there are open source alternatives.
If the vendor doesn't offer a downloadable version you're out of luck. If just you want to try out the ideas, Google for an open source alternative and try it out.
Try http://technet.informatica.com/. Be warned that Informatica makes it hard to find what you are looking for. I have been using it for seven-plus years -- very powerful, but very expensive and poorly constructed. Look carefully at open-source solutions, too.
As far as downloading, I vaguely remember something called a "Personal Edition" intended for evaluation, but I could not find it on their website.
Oh, I found it. $500 for a "limited version" that expires in one year. Look for "PowerCenter Developer Edition Request Form".
I have used Microsoft's 2005 ETL tool SSIS and Pentaho's Kettle (now called PDI), but not informatica. Of those 2, Pentaho was better than Microsoft and a free download to boot. So I would recommend adding Pentaho to any ETL evaluation shortlist.