m m2
space
Search Courses  in 

Get COURSE FEES & Discounts from BEST Informatica Institutes in Kanpur!

 

My Area

 

My Name

My Mobile Number

My Email ID

Informatica training in Kanpur - Top institutes with Course Fees

List of 2+ Informatica training institutes located near to you in Kanpur on October 21, 2020. Get access to training curriculum, course fees, contact phone numbers and students reviews.

 

Kanpur City, Kanpur
No Reviews. Write a Review

 

training institute

HTechSoft classes are Informatica, Informatica Data Quality, Informatica Realtime, Informatica powercenter course fees.
 
Shyam Nagar, Kanpur

 

training institute

Developerzon classes are Informatica, Informatica Data Quality, Informatica ETL, Informatica powercenter course fees.
 
First << 1  >> Last

Informatica training institutes in kanpur - List by Location

 

 

 

 

 

 

 

 

Course content & topics of Informatica Training in kanpur

Informatica course content and key topics covered in kanpur may vary from one training institute to another training provider . However our Informatica course training experts kanpur has identifed the list of topics which helps job oriented course training and most of the course content are focused on Informatica placement training course training. The Informatica course syllabus covers basic to advanced level course contents which is used by most of Informatica training classes in kanpur.

 

Data Warehousing Concepts
1.Data Warehouse
2.Data Mart
3.OLAP VS OLTP
4.Data Warehouse Architecture (Basic)
5.Data Warehouse Architecture (with a Staging Area)
6.Dimensional Modeling
7.Star Schema
8.Snowflake Schema
9.Dimension
10.Fact
11.Slowly Changing Dimension(Type 1,2 and3)
12.Hierarchy
13.Confirmed Dimension
14.Fact less Fact Table.
15.Summary / Aggregations table
16.Change Data capture

Power Center Components
1.Designer
2.Repository Manager
3.Workflow Manager
4.Workflow Monitor

Informatica Concepts and Overview
1.Informatica Architecture.
2.Source Qualifier
3.Target Designer
4.Transformations
5.Mappings
6.Mapplets
7.Sessions
8.Tasks

Sources
1.Working with relational Sources
2.Working with Flat Files

Targets
1.Working with Relational Targets
2.Working with Flat file Targets

Transformations
1.Expression Transformation
2.Lookup Transformation
3.Sequence Generator Transformation
4.Filter Transformation
5.Joiner Transformation
6.Sorter Transformation
7.Procedural Transformation
8.Router Transformation
9.Aggregator Transformation
10.Update Strategy Transformation
11.Union Transformation
12.Rank Transformation
13.Transaction Control Transformation
14.Normalizer Transformation
15.Source Qualifier Transformation
16.Stored Procedure Transformation
17.XML Source Qualifier Transformation
18.Debugging Mappings

Power Center Transformation Language
1.Numeric functions
2.String Functions
3.Date Functions
4.Conversion Functions
5.Cleansing Functions
6.Aggregate Functions
7.User Defined Functions

ADVANCED INFORMATICA CONCEPTS
1.Unconnected lookup Transformation
2.Unconnected Stored Procedure to Create and Drop Index
3.Mapplet and Types of Mapplets
4.Defining Reusable Transformations.
5.User Defined Functions
6.Tasks And Types of Tasks
7.Worklet and Types of Worklets
8.Scheduling Work flow
9.Constraint Based Load Ordering
10.Target Load Plan
11.Types of Batch Processing
12.Link conditions
13.Mapping Parameters
14.Mapping Variables
15.Defining Session Parameters
16.Session Recovery
17.Difference Between Normal and Bulk Loading
18.Push Down Optimization
19.PMCMD Utility
20.PMREP Utility
21.Incremental Aggregation

TYPES Of LookUp Caches
1.Static LookUp Cache
2.Dynamic LookUp Cache
3.Persistence lookup Cache
4.Shared LookUp Cache
5.Sorter and Rank Cache

Task Types
1.Session
2.Command
3.EMAIL
4.Timer
5.Event Wait
6.Event Raise
7.Decision
8.Assignment
9.Control
10.Worklet

ETL Testing
1.UNIT Testing
2.System Integration testing
3.PERFORMANCE TESTING
4.ETL Performance Optimization techniques


 

 

High Technologies Solutions - Delhi,Noida,Gurgaon

TrainerDesk Training Jobs

 

Training course fee & Discounts