Informatica primary uses load manager and data transformation manager
(dtm) to perform extracting, transformation and loading. Load manager reads
parameters and variables related to session, mapping and server and passes
the mapping parameters and variable information to the DTM.DTM uses this
information to perform the data movement from source to target
Informatica Data Quality Online Training - Informatica MDM Online Training - Informatica Online Training - - Data Ware Housing Concepts - Introduction to Data Warehousing - Introduction to OLTP - - ETL and OLAP Systems - Dimensional Modelling - Typs of Schema’s - Types of Fact and Dimension Tables - Why do we Need ETL tools - What is Informatica? - Power Centre Components - Informatica Architecture - Designer - Repository Manager - Workflow Manager - Workflow Monitor - Informatica Concepts and Overview - Source Qualifier - Target Designer - Transformations - Mappings & Mapplets - Sessions - Workflows & Work lets - Tasks - Sources - Working with Relational Sources - Working with Flat Files (Direct/Indirect) - Targets - Working with Relational Targets - Working with Flat file Targets - Transformations - Active and Passive Transformations - Connected and Unconnected Transformations - Reusable, - Non Reusable & Shortcuts - Expression - Source Qualifier - Filter - Joiner - Sorter - Rank - Router - Union - Aggregator - Sequence Generator - Lookup - Stored Procedure - Update Strategy - Normaliser - SQL Transformation - Transaction Control - Mapplet input and Output transformation - Implementation of Slowly Changing Dimensions - Type-1 - Type-2 - Type-3 - Cache concepts (Lookup, Aggregator, Joiner, Sorter) - Tasks - Start - Session - Assignment - Event raise and Event wait - Email - Command - Decision - Timer - Control - Advanced features - Incremental Aggregation - Mapplet Implementation - Target Load Plan - Target update override - Constraint Based loading - Mapping Parameters & Variables - Session Parameters - Link Conditions - Performance Tuning - Real Time scenarios & FAQ’s -
ReplyDelete