Informatica Training in Bangalore

Learn Informatica Course from Expert Oracle Trainers who are Real-time Working Professionals.
Expert Trainers | Practical Training | Mock Interviews | Placement Assistance | Job Support

Best Informatica Training in BTM Layout Bangalore

Based on Google and other third-party reviews, Softgen Infotech is recognized as one of the best Informatica Training in BTM Layout Bangalore. We have completed over 2000 Informatica training sessions with a 100% placement rate, assisting college students. For the past 5 years, the team at Softgen Infotech has been dedicated to providing High-Quality Informatica Training in BTM Layout Bangalore.

Softgen Infotech’s trainers come from the Informatica industry and have at least 5 years of experience implementing Informatica. All Informatica trainers are real-time specialists who provide hands-on experience with practicals.

Our Informatica Training in BTM Layout Bangalore is well equipped with labs and good infrastructure to provide you with hands-on training. We also offer Informatica certification training programmes. We have successfully trained and placed the majority of our students in large MNC firms. Softgen provides Informatica programmes with 100% placement assistance for our students.

 

Contact us and let us together build a perfect career for your future!

Enroll Today

    Why Choose Softgen Infotech

    Softgen Infotech is a leading Training Institute in Bangalore providing Quality Training for Multiple IT Courses with Placement Assistance.

    Live & Interactive Sessions

    Real Time Training

    Practical Classes

    Interview & Placement Assistance

    Need Advice?

    Worried or Confused whether this is the right course for you? Feel free to reach our Expert Consultant for all your Queries !

    Salesforce Training in Bangalore

    Course Material & Syllabus

    Get all Course Content and Syllabus. Get Trained like a  Professional. We Provide Course Material, Prepare for Interviews, Arrange Mock Interviews and 100 % Placement Assistance

    Informatica Training Objectives
     
    • Completeness- data missing or unusable?
    • Confirmity- data stored in a non standard format?
    • Consistency, Accuracy, Duplicates, Integrity.
    • Leverage Informatica s expertise in metadata reporting planning and deployment.
    • Understand the optimal Informatica architecture for your metadata needs.
    • Preview custom metadata reports and dashboards based on your project objectives and Informaticas best practice.
    • Metadata Reporting Enablement Strategy.
    • Metadata reporting standards.
    • Demonstration of Informaticas out-of-the-box and customized reports and dashboards based on your metadata requirements.
     
    Training Prerequesites
     
    • Basics of data ware housing
    • Good to have an idea about sql and pl/sql
    • Good to have a knowledge on Oracle database and its functionality
     
     Course Outline

    INTRODUCTION TO DATA WAREHOUSING
    Data warehouse concept
    Differences between Online Transaction Processing and data warehouse

    Types of Data Warehouse
     
    • Data warehouse Architecture
    • Difference between Data warehouse & Data mart
    • Data Warehouse Approaches
    • Data Warehouse Components
    • Logical & physical Design*
    • Operational data sources(ODS)
    • OLAP and its types: ROLAP, MOLAP, HOLAP, DOLAP
     
    TOOL KNOWLEDGE

    • Informatica PowerCenter
    • Product Overview
    • Power Center Domain
    • Administration Console
    • PowerCenter Repository
    • PowerCenter Client
    • Repository Service
    • INTEGRATION SERVICE
    • WEB SERVICES HUB
     
    MODELLING FOR DATA WAREHOUSE

    • Defining Fact, Dimension, Attributes, Hierarchies, Grain and Granularity
    • Grain and Granularity of Data
    • Fact Table
    • Dimension tables and types*
    • Data Warehouse Schemas*: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema
     
    REPOSITORY MANAGER

    • Adding a Repository to the Navigator
    • Configuring a Domain Connection
    • Connecting to a Repository
    • Viewing Object Dependencies
    • Validating Multiple Objects
    • Comparing Repository Objects
    • Truncating Workflow and Session Log Entries
    • Managing User Connections and Locks
    • Managing Users and Groups
    • Working with Folders
     
    POWERCENTER DESIGNER

    • Source Analyzer
    • Working with Relational Sources
    • Working with Flat Files
    • Target Designer
    • Mappings
    • Transformations
    • Working with Ports
    • Using Default Values for Ports
    • User-Defined Default Values
    • Tracing Levels
    • Basic First Mapping
    • Expression Transformation
    • Filter Transformation
    • Router Transformation
    • Union Transformation
    • Sorter Transformation
    • Rank Transformation
    • Aggregator Transformation
    • Joiner Transformation
    • Source Qualifier
    • Lookup Transformation
    • Lookup Types
    • Lookup Transformation Components
    • Connected Lookup Transformation
    • Unconnected Lookup Transformation
    • Lookup Cache Types: Dynamic, Static, Persistent, Shared
    • Update Strategy
    • Dynamic Lookup Cache Use
    • Lookup Query
    • Lookup and Update Strategy Examples
    • Stored Procedure Transformation
    • Connected Stored Procedure Transformation
    • Unconnected Stored Procedure Transformation
    • Sequence Generator Transformation
    • Mapplets: Mapplet Input and Mapplet Output Transformations
    • Normalizer Transformation
    • XML Sources Import and usage
    • Mapping Wizards
    • Getting Started
    • Slowly Changing Dimensions
    • Mapping Parameters and Variables
    • Parameter File
    • Indirect Flat File Loading
     
    WORKFLOW MANAGER
     
    • Working with Workflows
    • Assigning an Integration Service
    • Working with Links
    • Workflow Variables
    • Session Parameters
    • Working with Tasks
    • Session Task
    • Email Task
    • Command Task
    • Working with Event Tasks
    • Timer Task
    • Decision Task
    • Control Task
    • Assignment Task
    • Schedulers
    • Worklets
    • Partitioning
    • Partitioning Attributes
    • Partitioning Types
    • Session Properties
    • Workflow Properties
     
    ADVANCED TOPICS

    • Push down Optimization Technique .
    • Unit Testing .
    • Version Control .
    • Real time Scenario on Dynamic Lookup Cache .
    • Real time Scenario on Unconnected Stored procedure and lookup transformation .
    • Constraint Based Load Ordering .
    • Target Load Plan Order.

    Informatica Training Course Duration & Batch Timings

    Duration : 30 Hours Version : latest Version
    Regular : 1 Hour per day Fast Track : 2 - 3 Hours per day: 10 days
    Weekdays : Monday - Friday Weekend : Saturday and Sunday
    Online Training : Available Class Room Training : Available
    Course Fee : Talk to our Customer Support Mode of Payment : Talk to our Customer Support

    Frequently Asked Questions for Informatica Training Course

    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

    What Our Students Have to Say about Informatica Course

    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
    Kelvin Black
    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
    Zasha Swan

    Book A FREE Demo Today

    Worried or Confused whether this is the right course for you?

    Feel free to reach our Expert Consultant for all your Queries !