Informatica Powercenter ETL For The Absolute Beginner: With 12+ Hours of Video Tutorial Included

by SSRG

What am I going to get from this course?
•Over 154 lectures and 17.5 hours of content!
•Understand Basic Concepts of Data Warehouse
•Understand Various ETL Tools in Market and Why to Choose Informatica
•Idea of Real World ETL Projects
•Clear Understanding of Informatica Powercenter Architecture and Componenets
•Use of Informatica Powercenter ETL tool in real time project scenarios
•Perform Installation of Informatica Powercenter
•Understand Real Time Client-Server Architecture
•Understand Informatica ETL Developer Roles and Responsibilities
•Understand Informatica ETL Admin Roles and Responsibilities
•Use of various Transformation techniques like • Expression • Lookup –Different types of lookup Caches • Sequence Generator • Filter • Joiner • Sorter • Rank • Router • Aggregator • Source Qualifer • Update Strategy • Normalizer • Union
•Understand and Implement Slowly Changing Dimensions - • SCD Type1 • SCD Type2 — Date, Flag and Version • SCD Type3
•Use Workflow Manger in Real time projects for • Creating Reusable tasks • Workflows, Worklets& Sessions • Tasks • Session • Decision task • Control Task • Event wait task • Timer task • Monitoring workflows and debugging errors
•Able to perform - 1. Indirect Loading 2.Constraint based load ordering 3.Target Load plan 4.Worklet ,Mapplet ,Resuable transformation 5.Migration –XML migration and Folder Copy. 6.Scheduling Workflow 7.Parameter and variables 8.XML Source, Target and Transformations
•Implement Performance Tunning using Informatica
•Perform Project - Case Study
•Interview Questions & Answers
What is the target audience?
•Job seekers looking for exciting and well paid IT career
•Professionals looking for salary raise by adding new skill in their profile
•Fresher Graduates wanted to enter in IT market
•Anyone wants to do career change and want to switch to IT industry market

63 pages, Kindle Edition

Published October 29, 2015