Report for Webinar on “ Introduction to Informatica PowerCentre”

Report for Webinar on “ Introduction to Informatica PowerCentre”

Start

End

Report for Webinar on “ Introduction to Informatica PowerCentre”

A Webinar on “Introduction to Informatica PowerCentre” was organized by Department of Computer Science and Engineering in association with CSI, Geethanjali Institute of Science and Technology on 5th June , 2020. Around 600 participants from various states of India registered and participated in the webinar. Inaugural talk was given by Dr. Y. Jahnavi, HOD/CSE. The Resource person Mr. Ravi Teja P, Senior Data Engineer with Informatica, Informatica Business Solutions Private Limited, Bangalore, delivered the following content

  • Introduction to Data Warehousing
  • Introduction to OLTP, and OLAP Systems
  • Architecture of DWH
  • Different Types of DWH Tables(Fact tables & Dimension Tables)
  • Star Schema
  • Snowflake Schema
  • Staging Area
  • What is ETL
  • Different Types of ETL tools
  • How to Download Informatica PowerCentre
  • Informatica PowerCentre Architecture
  • Over View of Client & Sever tools
  • Types of Transformations
  • Examples Using Transformations
  • Understanding Slowly Changing Dimensions Type 1&2
  • Over view of sample project

The webinar was informative and covered the importance of Informatica PowerCentre in the real time applications. Received excellent feedback from the participants. e-Certificate was provided for the participants.