Mangesh Hajare

Years of Experience in Informatica Training

2

Teaching Experience in detail in Informatica Training

DAY 1: 1] Informatica and Oracle installation. 2] Informatica Architecture 3] Dataware housing Concepts. 4] Introduction to all client components Day 2: 1] Power center Designer Practical. File handling with Plane Transformation Delimited file Fix width file 2] Expression Transformation Examples on Expression Transformation. 3] Filter Transformation Examples on Expression Transformation. 4] Power center Workflow manager and its properties 5] Power center Monitor manager and how to check logs. Day 3: 1] Expression Transformation and Filter Transformation with oracle tables 2] Sorter transformation Examples on sorter Transformation. 3] Aggregator Transformation Examples on Aggregator Transformation. 4] QA section for all transformations covered Day 4: 1] QA section for all transformations covered 2] Router transformation 3] Theory related to all transformation 4] Sequence Generator transformation Day 5: 1] Joiner Transformation 2] Lookup transformation Day 6: 1] Transformation developer 2] Mapplet Designer Above two topic will cover reusable transformation and combine transformations 3] SCD Type-I Type-II Type-III Day 7: 1] Advanced Part of informatica Debugging,Target Load Plan ,Parameters and variables etc 2] Remaining transformations 3] Some Components of Workflow Manager 4] Migration of sessions and mapping Day8: 1] Remaining Components of Workflow Manager 2] Performance tuning. 3] Remaining theoretical Part regarding Power Center Day 9 and Day 10 1] Cover some scenarios ,interview questions and SCD 1 2 3 Manually Note : Not Strict schedule it may change according to student understanding . Given content cover only main points ,all theory part and more Example also cover along with that.