Informatica Realtime, Informatica powercenter (ETL)

Classes will be more descriptive and practical with real time industrial experience.

Assists for resume preparation and interview preparation.

Following topics will be covered as part of this basic course

• Learn Data Warehouse Concepts and ETL Concepts
• Understand Informatica PowerCenter architecture & its different components
• Learn to build Mappings, Tasks, Workflows
• Learn Mapping Parameter and Variables
• Learn debugging, troubleshooting and error handling using informatica
• Good exposure to various transformations with hands-on practical experience
• Active and passive transformations
• Source qualifier Transformation
• Aggregator Transformation
• Expression Transformation
• Lookup Transformation
• Filter Transformation
• Sequence Generator Transformation
• Stored Procedure Transformation
• Expression Transformation
• Router Transformation
• Sorter Transformation
• Rank Transformation
• Joiner Transformation
• Update strategy Transformation
• Transaction control Transformation
• Union Transformation
• Normalizer Transformation
• Sql transformation.
• Importing different type of sources 
• Assisting in interview preparation
• Informatica basic interview questions
• Informatica scenario based interview questions
• Miscellaneous topics
  
  
  • Post session and Pre-session commands
  • Pre sql and post sql
  • Mapping and session parameter
  • Incremental load and full load.
  • Normal and bulk load.