eTechno Soft is a prominent name in the bangalore's best Informatica training institutes. We are one stop solution for people looking for top and best Informatica training institutes in & at Bangalore. We offer best Informatica course training at BTM Layout, Bangalore with experienced trainers in Informatica industry. We provide 100% placement assistance and make you work on live projects.
eTechno Soft is rated as one of the Best Informatica Training Institute in Bangalore based on Google and other third party reviews. We have completed over 500 Training classes in Informatica and provided 100% placement assistance to students. Over the past 5 years, Team at eTechno Soft is dedicated to provide High-Quality Training in Informatica.
Trainers at eTechno Soft are handpicked from Informatica Industry and they have a minimum of 7 years of experience in implementing Informatica Technology. All Informatica Trainers are Professional real-time working consultants who offer hands on experience based on live scenarios.
Our Informatica training center in Bangalore is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide Informatica certification training program. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion Informatica Training course. We provide 100% placement support for our students.
We provide Class room trainings, online training, Weekend classes and Fast track course for best Informatica Training in Bangalore. Students have the option to select the course timings according to their convenience.
Course Material for Informatica is designed as per current scenarios and will help students in understanding the Informatica concept in detail. Our Informatica Training Syllabus covers all the topics related to Informatica Technology and gives a clear understanding of live scenario to students. Our Informatica experts at eTechno Soft Training Institute, Bangalore have developed a unique way of teaching Informatica in an efficient manner.
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.
- 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
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
- 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
- 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
- Source Analyzer
- Working with Relational Sources
- Working with Flat Files
- Target Designer
- 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
- 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
- Partitioning Attributes
- Partitioning Types
- Session Properties
- Workflow Properties
- 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 Batch Details in Bangalore
Informatica Training - Regular Batches (Morning, Day time & Evening)Batch Size : 15 (maximum)
Informatica Training - Weekend Batches (Saturday, Sunday & Holidays)Batch Size : 15 (maximum)
Informatica Training - Fast Track BatchesBatch Size : 10 (maximum)
|Course Name||Training Rating|
|Best Ab Initio Training Institute in Bangalore|
|Best Cognos Training Institute in Bangalore|
|Best Data Stage Training Institute in Bangalore|
|Best Informatica Training Institute in Bangalore|
|Best Teradata Training Institute in Bangalore|
eTechno Soft Solutions
4.85 out of 5 based on 5197 ratings.