ETL Informatica Training

Chapter 1: Power Center Components, Designer, Repository Manager, Workflow Manager, Workflow Monitor

Chapter 2: Informatica Concepts and Overview, Informatica Architecture., Source Qualifier3, Target Qualifier, Transformations, Mappings, Mapplets, Sessions, Tasks

Chapter 3: Sources, Working with relational Sources, Working with Flat Files

Chapter 4: Targets, Working with Relational Targets, Working with Flat file Targets

Chapter 5: Transformations, Expression, Lookup, Sequence Generator, Filter, Joiner, Sorter, Procedural, Router, Aggregator, Update Strategy, Data Concatenation, Debugging Mappings

Chapter 6: Mappings & Mapplets, Mapping Variables & Parameters, Creating Cubes & Dimensions, Working with Mapping Wizards

Chapter 7: Workflow Manger, Server Architecture, Workflows, Work lets & Sessions, Tasks, Assignments, Events, Command etc,

Chapter 8: Performance Tuning, Informatica Tuning (Source, target, mapping & Session), Oracle Tuning (Indexes, MV, Explain plan, Tkprof & SQL Hints)

Chapter 9: Project – Case Study

Chapter 10: Project – Review and Assignment Distributed systems Scheduling tools:, Autosys, Autosys Vs Informatica Scheduler.

Chapter 11: Oracle Concepts (10.0g ), Oracle Objects, DDL Statements, DML Statements, TCS Statements, Sub Query, Correlated Sub Query, Oracle Analytical functions, Views, Materialized views, PL/SQL.

Chapter 12: Data warehouse Concepts, Data Warehouse, Data Mart, OLAP VS OLTP, Data Warehouse Architecture (Basic), Data Warehouse Architecture (with a Staging Area), Dimensional Modeling, Star Schema, Snowflake Schema, Dimension, Fact, Slowly Changing Dimension, Hierarchy, Confirmed Dimension, Fact less Fact, Summary / Aggregations table, Change Data capture

ETL Informatica Training