Home >> Training & Placement >> Informatica >> View

Informatica Data Quality Analyst Online Training | South Plainfield


30 Nov, 2018
157
Get 35 hours of Informatica Training Classes with real time experts and improve your knowledge of IDQ Software Tool. Also, learn data integration process essential to build and restore data into a single entity known as Informatica PowerCenter.
Informatica Data Quality Analyst Online Training

Course Content:

Data Warehousing Concepts:

Data Warehouse
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a Staging Area)
Dimensional Modeling
Star Schema
Snowflake Schema
Dimension
Fact
Slowly Changing Dimension(Type 1,2 and3)
Hierarchy
Confirmed Dimension
Fact less Fact Table.
Summary / Aggregations table
Change Data capture

Power Center Components:

Designer
Repository Manager
Workflow Manager
Workflow Monitor

Informatica Concepts and Overview:

Informatica Architecture.
Source Qualifier
Target Designer
Transformations
Mappings
Mapplets
Sessions
Tasks

Sources:

Working with relational Sources
Working with Flat Files

Targets:

Working with Relational Targets
Working with Flat file Targets

Transformations:

Expression Transformation
Lookup Transformation
Sequence Generator Transformation
Filter Transformation
Joiner 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
XML Source Qualifier Transformation
Debugging Mappings

Power Center Transformation Language:

Numeric functions
String Functions
Date Functions
Conversion Functions
Cleansing Functions
Aggregate Functions
User Defined Functions

Advanced Informatica Concepts:

Unconnected lookup Transformation
Unconnected Stored Procedure to Create and Drop Index
Mapplet and Types of Mapplets
Defining Reusable Transformations.
User Defined Functions
Tasks And Types of Tasks
Worklet and Types of Worklets
Scheduling Work flow
Constraint Based Load Ordering
Target Load Plan
Types of Batch Processing
Link conditions
Mapping Parameters
Mapping Variables
Defining Session Parameters
Session Recovery
Difference Between Normal and Bulk Loading
Push Down Optimization
PMCMD Utility
PMREP Utility
Incremental Aggregation

TYPES of LookUp Caches:

Static LookUp Cache
Dynamic LookUp Cache
Persistence lookup Cache
Shared LookUp Cache
Sorter and Rank Cache

Task Types:

Session
Command
EMAIL
Timer
Event Wait
Event Raise
Decision
Assignment
Control
Worklet

ETL Testing:

UNIT Testing
System Integration testing
PERFORMANCE TESTING
ETL Performance Optimization techniques
Contact 732-978-4774
Submit Your Comment
Subscribe for newsletter
NJ NRI's Chat (0 Users Online)