New Batch Available Weekday & Weekend En roll yourself Today

Informatica Programming Course

Informatica is a Software development company, which offers data integration products. ... Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL. Informatica Powercenter is used for Data integration.

Pay Fees After Satisfaction With Interview Guidance Download

Data Warehousing Concepts
Data Warehouse(Basic)
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (with a Staging Area)
Dimensional Modelling : 1)Star Schema 2)Snowflake Schema
Dimension
Slowly Changing Dimension(Type 1,2 )
Fact: : Additive Fact, Semi Additive Fact, Fact less Fact Table.
Change Data capture
Power Centre Components
Repository Manager
Workflow Manager
Workflow Monitor
Informatica Architecture
Source Qualifier
Target Designer
Transformations
Mappings
Mapplets
Sessions
Tasks
Power Centre Components
Repository Manager
Workflow Manager
Workflow Monitor
Sources
Working with relational Sources
Working with Flat Files
Target Designer
Transformations
Mappings
Mapplets
Sessions
Tasks
Targets
Working with Relational Targets
Working with Flat Files
Expression Transformation
Lookup Transformation
Sequence Generator Transformation
Filter Transformation
Joiner Transformation
Sorter Transformation
Sorter Transformation
Procedural Transformation
Router Transformation
Aggregator Transformation
Update Strategy Transformation
Union Transformation
Rank Transformation
Transaction Control Transformation
Normalizer Transformation
Source Qualifier Transformation
Stored Procedure Transformation
Power Centre Transformation Language
Numeric functions
String Functions
Date Functions
Conversion Functions
Aggregate Functions
User Defined Functions
Unconnected lookup Transformation
Unconnected Stored Procedure to Create and Drop Index
Mapplet
User Defined Functions
Tasks And Types of Tasks
Worklet
Scheduling Work flow
Target Load Plan
Link conditions
Mapping Variables
Defining Session Parameters
Session Recovery
Difference Between Normal and Bulk Loading
Push Down Optimization
TYPES Of Look Up Caches
Static LookUp Cache
Dynamic Look Up Cache
Persistence lookup Cache
Shared LookUp Cache
Interview Preparation
Personal Interview
Group Discussion