Informatica Tutorial - Informatica Online Training
Learn Informatica PC ETL Development tool online with examples.
3.93 (857 reviews)
4,314
students
23.5 hours
content
Mar 2017
last update
$59.99
regular price
What you will learn
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
Screenshots
Related Topics
514066
udemy ID
5/28/2015
course created date
4/4/2020
course indexed date
Bot
course submited by