Informatica Training Informatica PowerCenter Ramy Mahrous
Informatica Syllabus
Data warehouse Concepts What is Data Warehouse? OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modelling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension
Informatica Syllabus
Introduction toIInformatica PowerCenter PowerCenter 9 architecture Extraction, Transformation and loading process Power Center tools PowerCenter Components Designer Repository Manager Workflow Manager Workflow Monitor
Informatica Syllabus
Informatica Concepts and Overview Informatica Architecture. Transformations Active and Passive Transformations Mappings Mapplets Sessions Tasks
Informatica Syllabus
Sources Relational Tables (Oracle) Flat Files (fixed width, Delimiter Files) Xml Files Targets Working with Relational Targets Working with flat file Targets
Informatica Syllabus Transformations Expression Lookup Sequence Generator Filter Joiner Sorter Stored Procedure Union Router Aggregator Update Strategy Expression Debugging Mappings
Informatica Syllabus
Mappings & Mapplets Mapping Variables & Parameters Working with Mapping Wizards Workflow Manger Workflows, Worklets Session Task, Email task, Decision task, Event wait & Event raise, Assignment task, Command task Performance Tuning Partition – Pipeline, Dynamic Informatica Tuning (Source, target, mapping & Session)
Thank You
No. 5/3, Second Floor and Third Floor, BEML Layout, Varathur Road, Thubarahalli, Kundalahalli Gate, Bengaluru, Karnataka - 560066 Mob : 095133 32301 Mail : info@tibacademy.in Web : www.traininginbangalore.in