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.

113 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
    4. Hi Goutham,

      Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.
      Given this, I would be surprised to see anything on the test that was not covered in the modules, as it relates to the Cloud tool and topics covered about IDQ. I would presume questions that test general ETL transformation knowledge based on past Power Centre tool experience.
      Once the data has been cleansed and standardized, duplicate records can be identified using various different matching techniques. This is also a developer task performed in the Developer Tool.

      But great job, do keep posted with the new updates.

      Kind Regards,

      Delete
    5. Hello Goutham,

      Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.

      Since posting this, I did a little more research.  Looks like the @ and : characters are not legal.  And that they need to be URL encoded.
       
      I tested this.  When unencoded, the hyperlink is broken.  When encoded, the hyperlink renders properly.
      A major benefit of Informatica Data Quality(IDQ) is increasing confidence and trust in enterprise data by making data quality more visible and more relevant to the business Informatica IDQ training USA.


      It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
      Keep up the good work!

      Merci,
      Kevin

      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
    Replies
    1. Hi Mate,


      Amaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?

      As of now i can think of one logic dont know how far it works ...lets give a try and let me know.

      Create another mapping and try to create a dynamic paramter file with the lookup value you are discussing ( Just a target file with one column as string datatype (255).)

      like $$Expr_Var=A+B+C

      And the main mapping you define a mapping variable $$Expr_Var (Make sure you select IS_EXPR_VAR is true. Use the parameter file in the session and use the above variable in the calculation..so it will treat as a expression rather than mere string value.

      Hope it should work.






      Awesome! Thanks for putting this all in one place. Very useful!


      Many Thanks,

      Delete
  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
  19. can you share information about IDQ

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

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

    ReplyDelete
  22. super material please visist www.dwbiadda.com all trainers are real time employees

    ReplyDelete
  23. Hii gowtham😊
    I m very thankful to u as u created a awesome blog which include almost all things of informatica power center.
    This is very useful for begginers like me.
    Also i have request can u pls add section of how to create automatic parameter file?

    ReplyDelete

  24. thank you for your wonderful information on informatica keep sharing thank you
    visit our site to learn
    learn Advanced informatica!

    ReplyDelete
  25. Great piece of information, easier to understand and lookup for notes.
    Thank you,
    Zeenat

    ReplyDelete
  26. Very useful article thank you for sharing this article. Informatica Data Quality Training

    ReplyDelete
  27. Really, these quotes are the holistic approach towards mindfulness. In fact, all of your posts are. Proudly saying I’m getting fruitfulness out of it what you write and share.

    Informatica Training in Chennai

    ReplyDelete
  28. Hi Gowtham Brother,

    Am new for this software please share the study material for practice purpose to my mail id harinath.ps@gmail.com

    ReplyDelete
  29. Very well explained view about Informatica.. It is easy to understand for beginners. Keep sharing your knowledge

    Informatica training in Chennai
    Informatica Admin training in Chennai

    ReplyDelete
  30. Thanks for sharing a good information about informatica. Informatica_Online_Training

    ReplyDelete
  31. Nice Information provided, please visit below for more information Informatica online training

    ReplyDelete
  32. Nice Information provided, please visit below for more information
    Informatica online training

    ReplyDelete
  33. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds
    and need to be patiently wait till it blossoms.

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete
  34. Croma campus placed in different places in noida. We are the best Training Institute offers certification orient Informatica Training in Noida. Our participant will be qualified to clear all type of interviews at end of our session. We are structure a team of Informatica trainers and participant for their hope help and support in subject.

    ReplyDelete
  35. Very good information, keep writing. We do provide informatica powercenter training

    ReplyDelete
  36. Great post! I am see the great contents and step by step read really nice information.I am gather this concepts and more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
    PEGA Training in Chennai

    ReplyDelete
  37. Very Useful information for the people who want to move ahead of the ETL Tool. First of all you need to know about Why to Choose Informatica as a career .
    Learn Informatica Training

    ReplyDelete
  38. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.
    PEGA Training in Chennai

    ReplyDelete
  39. Interesting blog which attracted me more.Spend a worthful time.keep updating more.
    Digital marketing company in Chennai

    ReplyDelete
  40. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  41. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    SEO Company in India

    ReplyDelete
  42. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete
  43. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete
  44. nice post thanks for giving basic concept about informatica.i realy wanted to use your information about informatica course to my carreer this one of the platform to develop programming language..


    Informatica training in chennai

    ReplyDelete
  45. Thanks for sharing this beautiful blog – GrewBox provide best information for SAS Training in Delhi

    ReplyDelete
  46. Very nice post here thanks for it I always like and search such topics and everything connected to them. Keep update more information..


    MSBI Training in Chennai

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete
  47. Hi,

    Your blog content is exactly what I need, I like your informatica blog, I sincerely hope that your blog is a fast-growing traffic density, and to help promote your blog, we hope you blog updates and place can always be colorful.

    ReplyDelete
  48. Hi,

    There is a BI report and i want to know the source query of three columns only from that BI report in informatica.Please tell me the process how to get the query from mapping for that individual columns only.
    Hope to get the answer from you ASAP.
    Thanks

    ReplyDelete
    Replies
    1. There is no BI Reporting for Informatica mapping, but if you have access to Repository Metadata Database you can find it easily.

      Thanks,
      K Gowtham

      Delete
    2. how?could you pls tell the process.

      Delete
  49. Replies
    1. Ohayo,


      Allow me to show my gratitude bloggers. You guys are like unicorns. Never seen but always spreading magic. Your content is yummy. So satisfied.

      Oracle OpenWorld combines product information and strategy with customer stories to help attendees discover and chart their journey to the cloud. Driven by over 180 sessions led by independent user groups and Oracle, the theme will focus on customer choice and how customers can modernize and extend their on premise solutions through Oracle Cloud and community engagement with user groups. Below is a Informatica IDQ training USA sampling of some of the content themes taking place on Sunday at OpenWorld.
      Follow my new blog if you interested in just tag along me in any social media platforms!

      Thank you,

      Delete
  50. TIB Academy is one of the best Informatica Training Institute in Bangalore. We Offers Hands-On Training with Live project.

    ReplyDelete
  51. very detailed description,loved reading the article.
    UI online course

    ReplyDelete
  52. I read your blog it's really good, thanks for sharing valuable information with us. Keep share content on Informatica Online Training

    ReplyDelete
  53. This is the good information for beginners really awesome and understandable keep share and update. Thank you Informatica Online Training

    ReplyDelete
  54. Nice blog Content. It is very informative and helpful. Please share more content. Thanks.
    AWS Training in Noida
    AWS Course in Noida
    AWS Institute in Noida

    ReplyDelete
  55. This is really a nice and informative, containing all information and also has a great impact on the new technology. Thanks for sharing it. Techavera providing the best  
    Informatica training course in noida
    AWS training course in noida
    MongoDB training course in noida
    StaadPro training course in noida
    Revit training course in noida
    Visit us For Quality Learning.

    ReplyDelete
  56. Thanks for this great share. This site is a fantastic resource. Keep up the great work here at Sprint Connection. This is really very massive value to all the readers and it will be the only reason for the post to get popular with great authority. Learn detailed about informatica ETL Tools for that information Click Here Informatica ETL Tool and its Features

    ReplyDelete
  57. This blog is so impressive. Glad to come across this useful information. Keep sharing
    SAS Training in Delhi

    ReplyDelete
  58. Nice article, users are attracted when they see your post thanks for posting keep updating Informatica Online Training


    ReplyDelete
  59. Hello all,

    Hello all . I want to learn how to load into teradata database (DW database )
    using Informatica PowerCenter .

    These are the things that I want to learn .
    1. Load using ODBC connection .
    2. Load using teradata loader utilities ( i.e. Multiload, Tpump, FastExpory , TPT , Bteq etc .)
    3. Database,user & profile creation in teradata database .

    Can anyone help me with these. Or. Suggest who can teach me & how much will it cost ?

    ReplyDelete
  60. I appreciate your work on Informatica. It's such a wonderful read on Informatica.Keep sharing stuffs like this. I am also educating people on similar technologies so if you are interested to know more you can watch this:-
    https://www.youtube.com/watch?v=56vMQ1lG-vc

    ReplyDelete

  61. I appreciate your work on Informatica. It's such a wonderful read on Informatica.Keep sharing stuffs like this. I am also educating people on similar technologies so if you are interested to know more you can watch this:-
    https://www.youtube.com/watch?v=56vMQ1lG-vc

    ReplyDelete
  62. This information you provided in the blog that is really unique I love it!! Thanks for sharing such a great blog. Keep posting..
    Informatica training in Noida
    Informatica training institute in Noida
    Informatica course in Noida

    ReplyDelete
  63. Nice article!This article provides good information.Please visit Informatica Tutorial for beginners for more information on Informatica Powercenter.

    ReplyDelete
  64. Nice article,your blogs gives a lot of information,it is good keep update the blogs like this
    Informatica Data Quality IDQ Training in Hyderabad
    IDQ COurse Content
    IDQ Interview Questions

    ReplyDelete
  65. I appreciate your work on Blockchain. It's such a wonderful read on Blockchain.Keep sharing stuffs like this. I am also educating people on similar technologies so if you are interested to know more you can watch this:-
    https://www.youtube.com/watch?v=GoFK7Tlvk2w

    ReplyDelete
  66. This really has covered a great insight on Informatica. I found myself lucky to visit your page and came across this insightful read on Informatica. Please allow me to share similar work on Informatica. Watch and gain knowledge today.
    https://www.youtube.com/watch?v=56vMQ1lG-vc

    ReplyDelete
  67. Hello Mate, Thanks for your post! We Need More about Qlikview Vs Informatica. Once again thanks for the blog.

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

    ReplyDelete

  69. This really has covered a great insight on Informatica. I found myself lucky to visit your page and came across this insightful read on Informatica. Please allow me to share similar work on Informatica. Watch and gain knowledge today.
    https://www.youtube.com/watch?v=56vMQ1lG-vc

    ReplyDelete
  70. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    sas analytics training

    ReplyDelete
  71. Marhaba,

    Smokin hot stuff! You’ve trimmed my dim. I feel as bright and fresh as your prolific website and blogs!

    As per reply from Nico, every installation is unique and it is only possible to give general guidelines without knowing specific details about your installation.
    That said, here are some things to consider...
    Repository and EDW database
    Everything PowerCenter does involves the repository database.
    Most of your ETL processing will involve the EDW database.
    Read the installation guide about the repository database and the EDW database and make the recommended settings. Consider page size and locking behaviour.
    What size packets are you using? Could you be using bigger packets?
    Also check the knowledge base for articles relating to your repository and EDW databases.
    Consider database location. The closer to the Informatica server the better.
    • Disk technology and network technology
    Every time data moves either to or from an executing job, it costs you time.
    Database reads, database writes, file access, swap files and Informatica cache files all slow you down.
    Solid state disks are faster then traditional hard drives. Solid state storage arrays are faster still.
    Fibre (fiber) is better than copper. Multi channel is better than single channel.
    Application platforms are worth investigating.
    • The Informatica Server itself.
    Informatica loves memory. If you can give it enough memory so that it can complete active transformation activities in memory, you're on to a winner. Read the performance tuning guide regarding optimizing transformations.
    Did you know... If the sorter transformation can't sort the complete data set in memory, it will send it all to disk and do the sort from disk. Very expensive!
    Use the memory settings (Auto memory and specific transformation memory) in the session to keep as much processing in memory as possible.
    Have the cache folder location local to the server and make it big.
    • Housekeeping, maintenance, troubleshooting and reviews.
    Use all the tools you can to review and analyse your environment.
    Investigate long running workflows/sessions and try to boost their performance.

    Great effort, I wish I saw it earlier. Would have saved my day :)

    Thanks,
    Irene Hynes

    ReplyDelete
  72. Nice post ! Thanks for sharing valuable information with us. Keep sharing..Informatica Online Training

    ReplyDelete
  73. Hi Mate,


    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.
    I started using Informatica IDQ training USA blog for my training practice.

    could you please check the link again that you've sent? I only get an error message that a Sharepoint error had occurred.

    As of my understanding the PowerExchange products cannot be used with PowerCenter Express (PCX). PCX does provide quite a few connectivity options, so if you can find some ODBC or JDBC driver to access SFDC you might be able to get your job done. Otherwise I fear you will have to switch to one of the full-fledged PowerCenter or Informatica Data Quality products.





    But great job man, do keep posted with the new updates.


    Best Regards,
    Krishna kumar

    ReplyDelete
  74. Thank you.Well it was nice post and very helpful information onInformatica Online Course india

    ReplyDelete
  75. IMPRESSIVE.thanks for sharing the information.
    Indian Cyber Army’s most awaited internship is live now. Summer Internship 2018 on “ Ethical hacking” and book your seats before it runs out.Candidates have to get themselves registered to be a part of this Internship program. Here internship will give you on-the-job experience, help you learn whether you and Cyber security industry are a good match and can provide you with valuable connections and references. Here interns are usually exposed to a wide variety of tasks and responsibilities which allows the intern to showcase their strengths by working on projects for various managers that work on different parts of Indian Cyber Army. Becoming a high performing intern is a fantastic way to improve your employment prospects. This internship can be a great way to get your foot in the door of success with a prestigious or desirable Organization.As career in ethical hacking is most in demand.

    ReplyDelete
  76. really Good blog post.provided a helpful information.I hope that you will post more updates like thisInformatica Online Course

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

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

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

    ReplyDelete
  80. Thanks for providing your information, keep update and share with more information regarding Informatica get touch with Informatica Online Training Bangalore

    ReplyDelete
  81. Terrific post however , I was wondering if you could write a litte more on this subject? I'd be very grateful if you could elaborate a little bit more. Thank you!
    http://www.abtrainings.com/courses/informatica-online-training/

    ReplyDelete
  82. Excellent article. Very interesting to read. I really love to read such a nice article Informatica Online Training Hyderabad

    ReplyDelete
  83. Thanks for the information.It is really nice .Information security is the set of processes that maintain the confidentiality, integrity and availability of business data in its various forms.In this age of Technology advancement, computer and information technology have not only brought convenience to citizens in modern life but also for policemen & various Government officials of the nation to fight cybercrime through various modus operandi. Indian Cyber Army has been dedicated in fighting cyber crime, striving to maintain law and order in cyberspace so as to ensure that everyone remains digitally safe.Read more:- Information Security

    ReplyDelete
  84. The information which you have provided is very good. It is very useful who is looking for selenium Online Training

    ReplyDelete