Saturday, March 16, 2013

What is Informatica?

Informatica is a ETL tool provided by 'Informatica Corporation', it is used to Extraction, Transformation and Load process all types databases. Now a day’s Informatica is also being used as an Integration tool and it is Service Oriented Architecture.

Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases/Flat Files.

Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.

PowerCenter is Informatica's enterprise-wide data integration platform solution. It is used to access, transform, and integrate data from a large variety of systems and deliver that information to other systems. It enables organizations to create a single, consistent enterprise-wide information resource and get a holistic view of the data.
PowerCenter Options
  • Partitioning: using parallel processing on multiprocessor hardware, partitioning optimizes performance by using multi-threaded processes
  • Real-time: augments the ability to execute processes on demand and in batch from previous versions
  • Data Cleansing: Informatica has partnered with companies such as FirstLogic and Trillium whose core competency is the standardization of name and address information
  • Data Profiling: allows Informatica developers and other data warehouse practitioners (with a bit of training) to perform data analysis on source data before building mappings
  • Metadata Exchange: provides the ability to easily detect changes between data models or BI tools, and objects in the Informatica repository

Informatica PowerCenter consiste of Client and Server Components are listed below:
·         PowerCenter Client Tools
·         PowerCenter Repository Service
·         PowerCenter Integration Service
·         Analyst Service
·         Model Repository Service
·         Data Integration Service
·         Web Services Hub
·         Metadata Manager Service
·         SAP BW Service
·         Reporting Service
·         Content Management Service
·         Reporting and Dashboards Service
·         PowerExchange Listener Service
·         PowerExchange Logger Service

Major Tools are PowerCenter Client Tools, PowerCenter Repository Service, PowerCenter Integration Service and Administrator Console.


  1. awful piece of information, I had come to know about your blog from my friend vimal, mumbai,i have read atleast 13 posts of yours by now, and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a million once again, Regards,informatica online training

    1. Dude...its not awful...Its awesome :P this article is good..

    2. lol :D :D btw good informatica website.... plz do post more on informatica and teradata... could u plz tell me is der any textbook for informatica... ?

    3. Is there any good books ...or any interesting info regarding sites...pleaseeee inbox me in avdvance

  2. Thank you for your valuable comments. I'd like to hear more from you and do not hesitate to share your feedback.

    P.s: Therz more coming...stay tuned :)

    1. gr8 Gowtham. You did excellent job in this article

  3. Thank you .
    it is really good content for beginner. I want to learn advanced concept in informatica , plz help me my email address is :

    1. Thanks for your valuable comments.
      Still I need to cover some basic concepts which takes some more time, once this is done I'll be posting advance concepts.

      Please keep visiting for advanced concepts.

  4. Very Nice Gowtham....great information.....Please post some realtime scenarious as well it will be helpful.....

    If you start something like that people will start adding their experiences in realtime....

  5. Hi Chandu, Soon i will be starting real time informatica scenarious page

    Expecting scenarious from developer/visitors.

  6. Good Job. I have just started learning Informatica. This helps to go in step by step. Good articulation. Expecting some hands-on to practise ourselves.

  7. Well presented details. Thanks.

  8. Really helpful and appreciate your efforts ... Cheers !

  9. Hi Gowtham,

    I have just started learning Informatica. Can you please give me your email Id to drop an email for any doughts.


  10. Hi Abhinay,

    Please visit contact page.

  11. very useful info, very good work Gowtham

  12. performance and tuning link is not working please check.......................
    your blog having more valuable data thank u for posting this type of posts...

  13. This comment has been removed by the author.

  14. Great work gowtham its really helping us

  15. Hi Gowtham...Its been a loooong time since I've seen this space...a reeli tremendous improvement, I would say...
    Words like "Thanks" or "Awesome" won't just measure your efforts which you are putting in to develop this space...

    p.s: please start an online coaching or do tell me if you have already started one...I just sent a mail to you regarding this and please do give a reply...

  16. hello gautham ..your tutorials are fantastic please can u explain me why i m getting this error

    "failed to initialize resource dll application will exit"

  17. Hi,

    If you can share error snapshot, I can help.


  18. Hi Goutham,

    This is very good information for beginners and it helps a lot.

  19. can you share information about IDQ

  20. Awesome information....Thanks much for sharing the excellent information on informatica

  21. This blog gives Information about Informatica Technology.

  22. Why dont u write same on other tools or languages.? I want to learn SQL management studio.