Courses Description

The course helps one to acquire knowledge in the PowerCenter 10 tool, ETL workflow processes, data warehousing concepts, and to create data mappings. Data integration by Informatica can connect, retrieve data, and process data from multiple sources. Hand-on experience in data integration jobs to optimize performance and efficiency. The advanced level of practical applications like Designer, Workflow Monitor, Workflow Manager, and creative transformation concepts.

Course content

• Introduction to PowerCenter Components
  • Extraction, Transformation, loading data, WorkflowManager, Repository Manager, Working with Flat Files,Informatica Architecture, PowerCenter Admin Console,and Designer Tools.
• Fundamental of ETL
  • Overview and Components of Informatica, What is ETL?
  • Informatica Architecture, Working with relational sources
  • Creating flat files and relational Targets.
  • Mappings Designer, ETL Overview.
• Repository Manager
  • What is a Repository? and Types of Repository in Realtime.
  • PowerCenter Repository Maintenance and Tools.
  • Domains Configurations.
  • Importing and Exporting Objects, Copying Objects.
• PowerCenter Transfromations(Advance)
  • Configuring and Reusable Transformation, Working withExpression and Ports.
  • Active and Passive Transformation.
  • Joiner Transfromation.
  • Aggregator Transformation.
  • Source Qualifier, Source Qualifier to Join Data.
  • Rank Transformation.
  • Sequence Generator.
  • Lookup, types of lookup caches.
  • Stored Procedure.
  • Union, Update Strategy Transformation..
  • SQL Transformation.
  • Router Transformation.
  • Dynamic File Generation, XML Files.
  • Creating and executing mapping.
  • Sorter Rank Transformation.
  • Mapplets.
  • Transaction Control.
  • Filter Transformation.
• Transformation Language
  • Functions.
  • Constants.
  • Operators.
  • Dates.
  • Variables.
• Module of Performance Tuning
  • Pipeline and Dynamic Partition.
  • Pushdown Optimization.
  • Caching and Memory Optimization..
• Slowly Changing Dimension
  • SCD Type1.
  • SCD Type2
  • SCD Type3.
• Workflow Manager
  • Introduction to Workflow, Worklets, and Session.
  • Tasks – Creating a Task, Configuring, Command,Decision, Event, Timer
  • Creating Reusable tasks and Sessions.
  • Debugging Errors
  • Monitoring Workflow.
• Target
  • Working with Relational Targets.
  • Working with Flat file Targets.
• Sources
  • Working with relational Sources.
  • Working with Flat Files.
• Others
  • Constraint-based load ordering.
  • Migration-XML migration and Folder Copy.
  • Target Load Plan.
  • Mapping Variables and Parameters.
  • Session Parameters.
  • Worklets and types.
  • Mapplet Designer.

Why Choose Tops Technologies ?

Highlights of Our Informatica Course

• Gain proficiency in 10+ Informatica tools including PowerCenter, MDM, and IDQ.
• Engage in 25+ real-world projects to tackle complex data integration and management challenges.
• Tie-ups with over 120+ top IT companies for exclusive job opportunities and industry insights.
• Join a network of professionals with alumni working across more than 20 countries.
• Access 100+ hours of content through both live and self-paced sessions.
• Advanced features like DAX (Data Analysis Expressions) in Power BI empower users to perform complex calculations and create sophisticated data models with ease.
• Benefit from 50+ hours of career services including mock interviews and job placement assistance.