Informatica Online Training and Placement

  Informatica Training for OPT CPT Students

Online Training Courses
.Net Online Training Courses Java Online Training Courses SAP Online Training Courses Oracle Online Training Courses Software Testing Online Training Courses C Programming Online Training Courses C++ Programming Online Training Courses jQuery Online Training Courses UI Design Online Training Courses UNIX Online Training Courses Javascript Online Training Courses SQL & PLSQL Online Training Courses SAS Online Training Courses BI Reporter Tool Online Training Courses Microstrategy Online Training Courses Mainframes Online Training Courses Business Objects Online Training Courses Business Analysis Online Training Courses BPM Online Training Courses Hadoop Online Training Courses DataStage Online Training Courses Android Online Training Courses Linux Online Training Courses OBIEE Online Training Courses IBM Tools Online Training Courses PHP Online Training Courses AJAX Online Training Courses BizTalk Online Training Courses Data Warehousing Online Training Courses Embedded Systems Online Training Courses Google Technologies Online Training Courses Microsoft Technologies Online Training Courses Oracle DBA Online Training Courses Oracle Datawarehouse Online Training Oracle E-Business Suite Online Training PeopleSoft Online Training Courses Project Management Online Training Courses Autocad Online Training Courses Salesforce Online Training Courses Sharepoint Online Training Courses Softskills Online Training Courses System Networking Online Training Courses Web Design Online Training Courses BizTalk Server Online Training Courses Database Online Training Courses iPhone App Development Online Training Ruby On Rails Online Training Courses SEO Online Training Courses Shell Scripting Online Training Courses VMWare Online Training Courses Webmethods Online Training Courses Websphere Online Training Courses Visual Basic Online Training Courses TIBCO SOA Online Training Courses COGNOS Online Training Courses Perl Scripting Online Training Courses Hyperion Online Training Courses Informatica Online Training Courses Python Online Training Courses QlikView Course Contents QA Online Training Courses Tableau Tool Online Training Courses Basic .Net Training Course
More    


Informatica Online Training 

Informatica Online Training Course Content


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 8.6.0

 

1. Power Center Components.

 

·         Power Center Clients

·         Power Center Repository.

·         Power Center Domain

·         Integration service

·         Repository Service

·         Administration Console

 

2. Difference between Informatica 7 and 8

 

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

Ø  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

17). Session Recovery

18). Difference Between Normal and Bulk Loading.

19). Push Down Optimization.

20). PMCMD Utility

21). PMREP Utility

22). Incremental Aggregation

23). TYPES Of LookUp Caches.

               a) Static LookUp Cache

                b) Dynamic LookUp Cache

                 c) Perisistance lookup Cache

                 d) Shared LookUp Cache

24). Sorter and Rank Cache.

25). ETL UNIT Testing (8 test Cases)

26). ETL PERFORMANCE TESTING (3 test cases)

27). ETL Performance

Optimization techniques

28). Task Implementations.

 

o   Session

o   Command

o   EMAIL

o   Timer

o   Event Wait

o   Event Raise

o   Decision

o   Assignment

o   Control

o   Worklet


Signup


Name: 

Phone No: 

Email:  

Password: 

Need Resume Preparation:     

 
Select Skills:
select skills and click ok to confirm
 
Select Sub Skills:    
select sub skills and click ok to confirm

Available Time:     (hold Ctrl to select multiple)

Register Now!

Free Demo Class
Register for a FREE DEMO class to attend IT Training courses with our experts online trainers. Register now by filling the below form. Take a DEMO and see how our online training courses work for you.






Which course is right for me?


Speak to an IT online learning consultant today


on 844-OPTGHAR for FREE Tailored Advice.

get free advice
course