Informatica Training in Bangalore

Informatica Training in Bangalore & Best Informatica Training Institutes in Bangalore

Best Informatica Training in Bangalore

Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Informatica Training Courses in bangalore. Our Informatica training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Informatica projects knowledge which will provide you an edge over other training institutes.


Our Informatica training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Informatica Training.  We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students.


Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Informatica Training course content and syllabus based on students requirements to achieve everyone\'s career goal.  Our Informatica Training course fee is economical and tailor-made based on training requirement.


We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Informatica Training in our centres located across bangalore. We also provide Online Training Classes for Informatica Training Course.


Contact us today to schedule a free demo and complete course details on Informatica Training Course.


Informatica Training Course Duration

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

ENROLL TODAY


RELATED COURSES


Informatica Training Course Content


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.