m m2
space
Search Courses  in 

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

 

My Area

 

My Name

My Mobile Number

My Email ID

Informatica training in Lucknow - Top institutes with Course Fees

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

 

Indira Nagar Colony, Lucknow

 

training institute
IICL (NCVT Govt of India) at Indira Nagar Colony - live discussions photo_19848 IICL (NCVT Govt of India) at Indira Nagar Colony - course brochures photo_19847 
Address: FIRST FLOR A-1 LEKHRAJ MARKET -1 Indira Nagar Colony Lucknow-226016

IICL (NCVT Govt of India) classes are Informatica, Informatica Realtime, Informatica Data Quality, Informatica powercenter course fees.
 
Hazratganj, Lucknow
No Reviews. Write a Review

 

training institute

Indusdrive Technologies classes are Informatica, Informatica powercenter, Informatica Realtime, Informatica Data Quality course fees.
 
Lucknow City, Lucknow
No Reviews. Write a Review

 

training institute
Address: Chola Complex, india nagar, Lucknow-226001

Jio Infotech classes are Informatica, Informatica Realtime, Informatica ETL, Informatica powercenter course fees.
 
First << 1  >> Last

Informatica training institutes in lucknow - List by Location

 

 

 

 

 

 

 

 

Course content & topics of Informatica Training in lucknow

Informatica course content and key topics covered in lucknow may vary from one training institute to another training provider . However our Informatica course training experts lucknow 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 lucknow.

 

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