Saturday, March 16, 2013

What is Informatica?

INFORMATICA POWERCENTER — OVERVIEW
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.

OVERVIEW:
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 ARCHITECTURE
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.

24 comments:

  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

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

      Delete
    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... ?

      Delete
    3. Is there any good books ...or any interesting info regarding sites...pleaseeee inbox me dhanya90m@gmail.com.....Thanks in avdvance

      Delete
  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 :)

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

      Delete
  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 : saurabh.dwh.etl@gmail.com

    ReplyDelete
    Replies
    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.

      Delete
  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....

    ReplyDelete
  5. Hi Chandu, Soon i will be starting real time informatica scenarious page http://gowtham-informatica-scenarios.blogspot.in.

    Expecting scenarious from developer/visitors.

    ReplyDelete
  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.

    ReplyDelete
  7. Well presented details. Thanks.

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

    ReplyDelete
  9. Hi Gowtham,

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

    Thanks,
    Abhinay

    ReplyDelete
  10. Hi Abhinay,

    Please visit contact page.

    ReplyDelete
  11. very useful info, very good work Gowtham

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

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. Great work gowtham its really helping us

    ReplyDelete
  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...

    ReplyDelete
  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"

    ReplyDelete
  17. Hi,

    If you can share error snapshot, I can help.

    Thanks,
    Gowtham

    ReplyDelete
  18. Hi Goutham,

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

    ReplyDelete