Location  Illinois   [ clear ]



 

  Classified         Views: 542

Informatica training at Futurepoint - Illinois

Informatica training at Futurepoint 

INFORMATICA POWERCENTER 9.1 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 5. What is ETL Client? 6. DataMart and Types of Data Marts. 7. DataWareHouse-Database Design. i) Star Schema. ii) Snow Flake Schema. iii) Galaxy Schema. 8. OLAP and Types of OLAPs 9. 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 2. Difference between Informatica 8.X and 9.X 3. Power Center Architecture 4. 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 con Orginally Posted at:

Price: Make Offer
Listing ID: 14938
    • Listing Began:
    • Mon, 23 May 2022
    • State
    • Illinois
    • City
    • Peoria
    • Price:
    • Make Offer
    • Time Remaining:
    • Auction starts on first bid
Futurepoint
Please be aware of scammers. Do not send money, give information or contact any untrusted entity. USA-classifieds does not ensure the identity of the publishers.

 Comments - Login Required

Be the first to post a question or comment on this listing.

Similar Classified Ads

SalesForce Administration Training at FuturePoint... Price: $0 USD Illinois, Western IL
SAP ABAP HANA Online Training at FuturePoint... Price: $0 USD Illinois, Peoria
CX Implementation CX Implementation... Price: $0 USD Illinois, Lisle
» More Similar Ads