INFORMATICA 9X IDQ ONLINE TRAINING

Informatica developer and analyst replaces the traditional informatica dataquality. Using developer you can profile your data, create score cards, address validation is carried out in the tool, names match,Analyst tool is more of a GUI based tool where business analysts can perform the same stuff that a developer can do from a developer tool. Not sure what exactly you are looking for but, There is nothing that these tools can replace powercente or vice versa. This is totally different and used for different purposes.

INFORMATICA 9X IDQ Online Training Course Content
  • Dq Overview
    • Data Quality Basic Concepts and life cycle.
    • DQ Rules, Scorecards, Reference tables, interoperability with powercenter
    • Profiling & Cleansing Concepts – Standardization, Merge, Match, de dup, label, parse.
  • informatica DQ Tools
  • Informatica Developer and Analyst Architecture – Client tool, Service and repository relationship.
  • Working on Informatica Developer objects
    • Physical Data Object
    • Logical Data Object Mapping
    • Logical Data Object Model
    • Profiling
    • Reference Table
    • Scorecard
    • Transformations
    • Rules/mapplets
  • Informatica Developer
  • Usage and properties of Data Quality Transformations
    • Match
    • Merge
    • Labeler
    • Standardizer
    • Address Validator
    • Association
    • Comparison
    • Consolidation
    • Parser
    • Decision
  • Working on below mentioned items in Informatica Developer
    • Create and validate Rules/Mapplets.
    • Create and run Mapping (use Mapplet within it).
    • Create and run Workflows.
  • Informatica Analyst Overview.
  • Creating column profile, rule and scorecard using Informatica Analyst.
  • Informatica Powercenter
  • Informatica Powercenter Architecture and overview.
  • Informatica Powercenter basic transformations overview.
    • Source Qualifier
    • Lookup
    • Expression
    • Sorter
    • Filter
    • Joiner
    • pdate Strategy
    • Normalizer
    • Aggregates
    • Sql
    • Stored proc
  • Informatica Powercenter mapping, session and workflow level Variables and Parameters.
  • Use of Informatica developer DQ rule as mapplet in Powercenter mapping.
  • Creating and setting properties in Powercenter Sessions and other tasks.
  • Creating and running Workflows.
  • New Features in Informatica 9.1 and 9.5.
  • Scheduling Powercenter workflows and monitoring the same.
  • Using Informatica provided Commands for various purposes.
    • Pmcmd
    • Infacmd
    • Infarep
  • Performance Optimization in Informatica Loads

Please Register with us