Thursday, 5 December 2013

Informatica Data Quality Online Training

 Informatica Data Quality Online Training    Call Us-001-201-210-8616 21st Century Software Solutions Online Training    http://www.21cssindia.com/courses/informatica-idq-online-training-98.html    21st Century providing Online training and support on All Technologies. If you are seeking training and support you can reach me on 91-9000444287. Online training by real time Experts. Call us 001-309-200-3848 for online training    contact@21cssindia.com
    Informatica MDM Online Training    Call Us-001-309-200-3848 21st Century Software Solutions Online Training    http://www.21cssindia.com/courses/informatica-mdm-online-training-99.html    21st Century providing Online training and support on All Technologies. If you are seeking training and support you can reach me on 91-9000444287. Online training by real time Experts. Call us 001-309-200-3848 for online training    contact@21cssindia.com
    Informatica Online Training    Call Us-91-900-044-4287 21st Century Software Solutions Online Training    http://www.21cssindia.com/courses/informatica-online-training-31.html    21st Century providing Online training and support on All Technologies. If you are seeking training and support you can reach me on 91-9000444287. Online training by real time Experts. Call us 001-309-200-3848 for online training    contact@21cssindia.com

Tuesday, 26 November 2013

informatica online training| informatica training| call us+ ...

  1. www.21cssindia.com/courses/informatica-online-training...   Cached
    Informatica Online Training: Click Here For Enquiry: Data Ware Housing Concepts . Introduction to Data Warehousing; Introduction to OLTP

Sunday, 21 July 2013

| Informatica Online Training | call us +917386622889

Informatica Online Training

Data Ware Housing Concepts                         Click Here For ENQUIRY

  • Introduction to Data Warehousing
  • Introduction to OLTP
  •  ETL and OLAP Systems
  • Dimensional Modelling
  • Types of Schema’s
  • Types of Fact and Dimension Tables
  • Why do we Need ETL tools
  • What is Informatica? 
Power Centre Components  
  • Informatica Architecture
  • Designer 
  • Repository Manager 
  • Workflow Manager 
  • Workflow Monitor 
Informatica Concepts and Overview  
  • Source Qualifier 
  • Target Designer 
  • Transformations
  • Mappings & Mapplets
  • Sessions
  • Workflows & Work lets
  • Tasks 
Sources  
  • Working with Relational Sources
  • Working with Flat Files (Direct/Indirect) 
Targets  
  • Working with Relational Targets
  • Working with Flat file Targets 
Transformations 
  • Active and Passive Transformations
  • Connected and Unconnected Transformations
  • Reusable,
  • Non Reusable & Shortcuts
  • Expression
  • Source Qualifier
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Union
  • Aggregator
  • Sequence Generator
  • Lookup
  • Stored Procedure
  • Update Strategy
  • Normaliser
  • SQL Transformation
  • Transaction Control
  • Mapplet input and Output transformation
Implementation of Slowly Changing Dimensions
  • Type-1
  • Type-2
  • Type-3
Cache concepts (Lookup, Aggregator, Joiner, Sorter)
  • Tasks
  • Start
  • Session
  • Assignment
  • Event raise and Event wait
  • Email
  • Command
  • Decision
  • Timer
  • Control
Advanced features
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Target update override
  • Constraint Based loading
  • Mapping Parameters & Variables
  • Session Parameters
  • Link Conditions
  • Performance Tuning 
Real Time scenarios & FAQ’s