Informatica Power Center Tutorials (11th-April-2016 Batch)

Click here to go to the Informatica Power Center Home Page>>

Chapter 1: Informatica Power Center Free Videos (4 Videos 3+ Hours)

If you are a member, login here. To apply for membership, please visit our Pricing page

Chapter 2: Informatica Power Center Videos Day 04 to Day 24

Orientation Day : Intro to Data warehousing, Informatica, What is Data warehouse and Informatica and ETL. Why you should learn Informatica, ETL definition,Informatica components, Informatica course structure, Pre requisites of Informatica?
Day 01: Informatica Architecture, Start schema Vs Snowflake schema. Installation steps of Informatica server and client tools.
Day 02: How to create Informatica repository services and Integration servioces, How to use these services in Informatica repository manager.
Day 03: Transformation types i.e active vs passive transformations, connected and unconnected trasformations. Introduction to Source Qualifier transformation.
Day 04: This video session covers Types of Trasformations and Source Qualifier transformation.
Day 05: This video covers about handling multiple sources in Source Qualifier and Handling of Flat files in targets.
Day 06: This video covers about flat file as source and target, flat file source to target data base loading, Filter transformation and introduction to Expression transformation.
Day 07: This Video covers more about the Expression transformation and functions available in the expression transformation.
Day 08: This Video talks about DECODE, ERROR handling and ABORT functionalities of Expression transformation.
Day 09: This Video talks about the Usage of Sorter Transformation and Joiner Transformation.
Day 10: This Video covers the Router transformation and difference between Filter and Router transformation.
Day 11: This Video covers the Aggregate transformation, Sequence generator transformation and Rank transformation.
Day 12: This Video talks about the Union transformation.
Day 13: This Video talks about the Connected and unconnected transformations.
Day 14: This Video talks about the Dynamic look up cache and update strategy.
Day 15: This Video covers the differences between Connected and unconnected look up, look up policy and how to return more than one port from connected look up.
Day 16: This Video covers the Explanation about Slowly Changing Dimensions (3 types SCD’s) and COding for SCD Type1.
Day 17: This Video covers the Mapping development for Slowly Changing Dimension type2 (SCD Type2).
Day 18: This Video talks about the Slowly changing dimension type3 (SCD Type3).
Day 19: This Video talks about the Informatica Variables and Parameters.
Day 20: This Video talks about the SQL transformation and stored procedure transformation.
Day 21: It talks about the Mapplets and Reusable transformations.
Day 22: It talks about the usage of PMCMD command and Advanced features of Session and workflow properties.


[Content protected for ITeLearn Informatica Power Center members only]

  • Member Testimonials

    Hiral desai

    Hi ITeLearn team....... Would like to definitely say that Karthik is an amazing tutor.....!!! He teaches really so well that my basics have become sooo... Read More
    2017-06-27T11:55:01+00:00
    Hi ITeLearn team....... Would like to definitely say that Karthik is an amazing tutor.....!!! He teaches really so well that my basics have become sooo clear which is ofcourse very important ­čÖé So kudos to him and please continue the great work ­čÖé

    Aviad Sar Shalom

    I learned QTP and Selenium with you.,I secured 2 jobs thanks to it, after passing 2 real tough technical interviews.. --The interviewer has no mercy,... Read More
    2017-06-27T11:55:28+00:00
    I learned QTP and Selenium with you.,I secured 2 jobs thanks to it, after passing 2 real tough technical interviews.. --The interviewer has no mercy, and try to tackle me no matter what,But it doesn't matter what he asked, after watching your videos, i felt that not just that i know much more than the interviewer..He cant even scratch the bottom of my knowledge.....

    Shailendra Kumar

    Excellent overview for Mobile application´╗┐ testing..Thanks alot..!!
    2017-06-30T12:28:56+00:00
    Excellent overview for Mobile application´╗┐ testing..Thanks alot..!!

    Samarth Santhosh

    Fantastic video for beginners.. Thanks a lot for uploading. The video could have been uploaded with a better video quality as the text appears to... Read More
    2017-06-30T12:23:51+00:00
    Fantastic video for beginners.. Thanks a lot for uploading. The video could have been uploaded with a better video quality as the text appears to be smudged and unclear. Looking forward for part5 and more.. (end of part4 questions´╗┐ put forth was really dumb!!)

    Devasena Radhakrishnan

    Firstly Thank you very much Karthik, Manoj and Shankar of ITeLearn Group. I joined ITelearn during April2016 to enhance my knowledge in Test Automation areas.... Read More
    2017-08-07T06:07:49+00:00
    Firstly Thank you very much Karthik, Manoj and Shankar of ITeLearn Group. I joined ITelearn during April2016 to enhance my knowledge in Test Automation areas. I went through QTP, Selenium and SoapUI. Also went through some free videos in other areas of myinterest. Surely it a great service from ITelearn group and I benefited a lot from it.
  •  

Leave a Reply

Your email address will not be published. Required fields are marked *