Informatica is available for all the popular platforms. It offers cloud-based services so that with minimal setup an industry can use this tool. Informatica offers real-time data integration, web services integration, Business to business data integration (B2B), Big data edition, Master Data Management and connectors for social media and Salesforce. Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.

What you will learn

After successfully completing this course, students should be able to :

  • Use Informatica Support to resolve questions and problems with PowerCenter 9.x
  • Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target, transforming it as necessary
  • Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets.
  • Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
  • Perform error handling/trapping using PowerCenter mappings
  • Use PowerCenter 9.x Workflow Manager to build and run a workflow which executes a sessions associated with a mapping
  • Design and build simple mappings and workflows based on essential business needs
  • Perform basic troubleshooting using PowerCenter logs and debugger
  • Execute performance tuning and Optimization
  • Recognize and explain the functionalities of the Repository Manager tool.
  • Identify how to handle services in the Administration Console
  • Gain insight on ETL best practices using Informatica

Informatica training is provided by real time work experience trainer with 10+ Years in IT industry. We Help you to change your current domain to Informatica domain and get a dream job.

Explore the BEST concepts

The course will introduce attendees to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. They will develop cleansing, formatting, sorting and aggregating procedures.

Data Warehousing Informatica Course Contents

  • An Overview of Informatica PowerCenter 9.x
    • Introduction to Informatica
    • Difference between Power mart and Power center
    • Informatica Architecture
    • Informatica Client Tools
      • Designer (Components)
        • Source Analyzer
        • Warehouse Designer
        • Mapping Designer
        • Mapplet Designer
        • Transformation Developer
      • Workflow Manager (Components)
        • Task Developer
        • Worklet designer
        • Workflow Manager
      • Workflow Monitor
      • Repository Manager
        • Creation of Groups and Users
        • Grant Permissions & Privileges
      • Repository Server Admin Console
        • Creating Repository
        • Deleting Repository
        • Backup
    • Informatica Server Tools
      • Repository Server
      • Server
        • Informatica Server Architecture
  • Transformations
    • Source Qualifier
    • Filter
    • Expression
    • Aggregator
    • Joiner
    • Router
    • Rank
    • Sorter
    • Sequence Generator
    • Union
    • Xml Source Qualifier
    • Lookup (Connected/Unconnected)
    • Stored Procedure (Connected/Unconnected)
    • Update Strategy
    • Transaction Control
    • Normalizer
    • Application Source Qualifier
    • Application multi-group Source Qualifier
    • Mapplet Input, Mapplet Output
  • Concepts
    • SQL Override
    • Working with files (Sources, Target)
    • File Repository Concept
    • Parameters : Mapping Parameters ,Mapping Variables ,Session Parameters
    • Incremental Aggregator
    • Scheduling
    • Debugging
    • Slowly Changing Dimension: Type 1,Type 2,Type 3