INFORMATICA Course Content



Data Warehouse
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Dimensional Modeling
Star Schema
Snowflake Schema
Dimension
Fact
Slowly Changing Dimension
Hierarchy
Confirmed Dimension
Fact less Fact
Summary / Aggregations table
Change Data capture
E T L INFORMATICA POWER CENTER 9
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
DATA STAGE ADMINISTRATO
Data stage project Administration
Editing projects and Adding Projects
Deleting projects Cleansing up project files
Environmental Variables
Environment management
Auto purging
Runtime Column Propagation(RCP)
Add checkpoints for sequencer
NLS configuration
Generated OSH (Orchestra Engine)
System formats like data, timestamp
Projects protect – Version details.
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
Perisistance lookup Cache
Shared LookUp Cache

Enquiry Form                         

CONTACT US

  1. 10521 Shadow Ridge Ln Apt 203,
  2. Louisville KY-40241
  3. Contact No : 606 909 4722
  4. Email : contact@coloursit.com

TESTIMONIALS

  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Kranthi Ch
MD, Siri IT Solutions



  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Sreedhar J
Manager, Siri IT Solutions

Copyright © 2014 Colours IT Consulting | All Rights Reserved.