Informatica Training

Duration : 35 Hours

Informatica Power Center is a powerful ETL tool from Informatica Corporation.

Informatica Corporation products are:

  • Informatica Power Center
  • Informatica on demand
  • Informatica B2B Data Exchange
  • Informatica Data Quality
  • Informatica Data Explorer

Informatica Power Center is a single, unified enterprise data integration platform for accessing, discovering, and integrating data from virtually any business system, in any format, and delivering that data throughout the enterprise at any speed.

DATAWARE HOUSING FUNDAMENTALS
  1. What is Database?
  2. What is Data Warehousing?
  3. Difference between OLTP Database and DWH.
  4. ETL FUNDAMENTALS.

i) Data Extraction

ii) Data Transformation

iii) Data Loading

  1. What is ETL Client?
  2. DataMart and Types of Data Marts.
  3. DataWareHouse-Database Design.

i) Star Schema.

ii) Snow Flake Schema.

iii) Galaxy Schema.

  1. OLAP and Types of OLAPs
  2. DataWareHouse Architecture.
INFORMATICA POWERCENTER 9.1
  1. Power Center Components.
  • Power Center Clients
  • Power Center Repository.
  • Power Center Domain
  • Integration service
  • Repository Service
  • Administration Console
  1. Difference between Informatica 8.X and 9.X
  2. Power Center Architecture
  3. Integration Service Architecture
TRANSFORMATIONS
a). ACTIVE TRANSFORMATIONS.
  • Filter Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Union Transformation
  • Sorter Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • Update Strategy Transformation
  • Normalizer Transformation
  • Source Qualifier Transformation
  • SQL Transformation.
b). PASSIVE TRANSFORMATION
  • EXPRESSION TRANSFORMATION
  • SEQUENCE GENERATOR TRANSFORMATION
  • STORED PROCEDURE TRANSFORMATION
  • LOOKUP TRANSFORMATION (Upgradations in 9.X)
  • XML SOURCE Qualifier Transformation.
c). CONNECTED AND UNCONNECTED TRANSFORMATIONS. d). FLAT FILES AND ITS TYPES.
POWER CENTER ADVANCED
  1. Unconnected lookup Transformation.
  2. Unconnected Stored Procedure to Create and Drop Index.
  3. Mapplet And Types Of Mapplets.
  4. Defining Reusable Transformations.
  5. User Defined Functions.
  6. Tasks And Types Of Tasks.
  7. Worklet and Types Of Worklets.
  8. Scheduling Work flow.
  9. Constraint Based Laod Ordering.
  10. Target Load Plan.
  11. Types Of Batch Processing.
  12. Link conditions.
  13. Mapping Parameters.
  14. Mapping Variables.
  15. Defining Session Parameters.
  16. Session Recovery.
  17. Difference Between Normal and Bulk Loading.
  18. Push Down Optimization.
  19. PMCMD Utility.
  20. PMREP Utility.
  21. Incremental Aggregation
  22. TYPES of LookUp Caches.
    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Persistence lookUp Cache
    • Shared LookUp Cache
   
  1. Sorter and Rank Cache.
  2. ETL UNIT Testing (8 test Cases)
  3. ETL PERFORMANCE TESTING (3 test cases)
  4. ETL Performance Optimization techniques
  5. Task Implementations.
    • Session
    • Command
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Assignment
    • Control
    • Worklet
Other Courses Offered
  • Android
  • AIX Administration
  • Business Analyst
  • CCNA, CCNP Security, CCIE
  • Citrix XenApp
  • Cognos 10 BI & Tm1
  • Crystal Reports
  • Data Stage
  • DB2 DBA
  • Dot Net
  • DAC
  • Google Web Tool Kit
  • IBM Lotus Notes (Development)
  • IBM Lotus Notes Domino Server Administration
  • IBM Message Broker
  • IBM MQ Series
  • IBM Tivoli Access Manager
  • IBM Web Sphere Application Server Administration (WAS)
  • IBM WAS Portal server Development
  • IBM Websphere Transformation extender (WTX 8.2)
  • Informatica
  • I Phone
  • Java/J2EE
  • J Query
  • MCITP
  • MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
  • Microstrategy
  • MicroSoft Business Intelligence
  • MicroSoft Dynamics CRM
  • OBIEE 11 g
  • Oracle APPS – HRMS
  • Oracle APPS – SCM
  • Oracle APPS – Financial
  • Oracle APPS – Technical
  • Oracle BI Apps
  • Oracle BI Publisher
  • Oracle DBA 11g
  • Oracle RAC
  • Oracle Fusion SOA
  • Oracle SQL , PL SQL
  • People Soft
  • PHP
  • Perl Scripting
  • SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS
  • Sales Force CRM
  • SharePoint Server 2010
  • Shell Scripting
  • Siebel CRM , EAI, E-Scripting
  • SQL Server DBA
  • Springs and Hibernate
  • Storage Area Network ( SAN)
  • Tera Data
  • Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
  • TIBCO BW, BE, TIBCO I Process
  • Tivoli Access Manager
  • Unix Administration
  • VN Ware
  • WCF, WPF, LINQ, AJAX, SILVER LIGHT
  • Webmethods
  • Webservices , SOAP ( JAVA)
 

Reviews

No reviews

Post Review

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

Technology Portfolio