Informatica tutorial for beginners
Informatica Powercenter Tutorials
Instructor
• ETL &DWH expert
• 10 Years of Industrial experience
• Informatica Expert
• Informatica PowerCenter is:
• Powerful
• Efficient
• Easy to learn
Course Contents
• Data warehouse Concepts
• Real World DW Project Example
• What is ETL?
• Various ETL Tools In market
• Informatica Components List
• Informatica Client-Server Architecture
• Role of Informatica Admin & Developers
• Installation & Configuration
• Mapping, Session and Workflow Creation
• Session Properties
• Link Condition Between Sessions
• Multiple Target and Target Load Plan
Course Contents
• Transformations
• Expression transformation
• Filter transformation
• Router transformation
• Lookup transformation
• Union transformation
• Sorter transformation
• Aggregator transformation
• Rank transformation
• Sequence generator transformation
• Stored procedure transformation
Course Contents
• Task, Session & Workflow properties
• Reusability - Worklet & Maplet
• Scheduling Workflow
• Import - Export of Objects
• Indirect File Load
• Integrity Constraint Load Ordering
• Session Parameters and Variables
• Target Load Order Plan
• Important Interview Questions for Informatica ETL
• Informatica Developer Resumes
Thank you