informatica Online Training Institute in India,USA,UK,Canada. - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

informatica Online Training Institute in India,USA,UK,Canada.

Description:

Informatica is ETL tool which is generally used for extracting the source information after utilizing the transformation which is requied, and loading it to the target. In another section we're planning to try to spell out the usage of Informatica using an example in the Data Warehouse atmosphere.we're supplying informatica Online Training in India,USA,UK,Canada. – PowerPoint PPT presentation

Number of Views:23
Slides: 24
Provided by: devidmaxwel
Tags:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: informatica Online Training Institute in India,USA,UK,Canada.


1
Informatica Online Training
2
Informatica Online Training Course Content
3
Data Warehousing Concepts
  • Dataware housing (what is Dataware
    housing /Why Dataware housing/How Dataware
    housing)    Slowly Changing Dimensions (SCD1,
    SCD2, SCD3)    Metadata    Dimentinal
    Table    Types Of Dim Tables    Fact
    Table    Types of Fact Tables

4
  •  OLTP (OnLine Transaction Processing)    OLAP
    (Online Analysis And Processing)    OLTP Vs
    OLAP    Advantages of OLAP    Different
    Methodologies of DWHPowerCenter Components and
    User Interface    Informatica

5
(No Transcript)
6
PowerCenter Architecture
  • Informatica PowerCenter Client Tools    Start
    Using of the Designer, Workflow Manager and
    Workflow Monitor

7
Informatica Online Training
  • Source Qualifier Transformation    SQL override
    in source qualifier transformation    Source
    qualifier transformation joins concept   
    Source qualifier transformation on Relational
    Databases    Source qualifier transformation on
    File systems

8
  • Source qualifier transformation filter
    concepts    Difference Between SQL Override,
    Other Options    Source Qualifier
    Transformation Performance Tunning    Pre SQL
    and Post in Source Qualifier TransformationExpress
    ion, Filter, File Lists and Workflow

9
Scheduler 
  • Filter Transformation    File Lists  
     Workflow Scheduler    Lab Load the Customer
    Staging Table and Real time issuesJoins, Features
    and Techniques I    Joiner Transformation  
     Shortcuts    Lab A Load Sales Transaction
    Staging Table    Lab B Features and
    Techniques I and Real time issues

10
Lookups and Reusable Transformations
  •  Lookup Transformation    Reusable
    Transformations    Lab A Load Employee
    Staging Table    Lab B Load Date Staging
    Table and Real time issues

11
Debugger
  •  Debugging Mappings    Lab Using the Debugger

12
Sequence Generator
  • Sequence Generator Transformation    Lab Load
    Date Dimension Table and Real time issues

13
Lookup Caching, More Features and Techniques
  •  Lookup Caching    Lab A Load Promotions
    Dimension Table    Lab B Features and
    Techniques II    Review and more Lab Activities
    and Real time issues

14
Router, update Strategy and Overrides
  • Router Transformation    Update Strategy
    Transformation    Expression Default Values  
     Source Qualifier Override    Target
    Override    Session Task Mapping Overrides  
     Lab Load Employee Dimension Table and Real
    time issues

15
Dynamic Lookup and Error Logging Informatica
Online Training
  •  Dynamic Lookup    Error Logging    Lab
    Load Customer Dimension Table

16
Unconnected Lookup, Parameters and Variables
  • Unconnected Lookup Transformation    System
    Variables    Mapping Parameters and
    Variables    Lab Load Sales Fact Table

17
Sorter, Aggregator and Self-Join
  • Sorter Transformation    Aggregator
    Transformation    Active and Passive
    Transformations    Data Concatenation  
     Self-Join    Lab Reload the Employee Staging
    Table and Real time issues
  • SCD type1 Hands-On LAB
  • SCD type2 Hands-On LAB
  • SCD type3 Hands-On LAB

18
Mapplets
  • Mapplets    Lab Load Product Daily Aggregate
    Table    Review and more Lab Activities and
    Real time issues

19
Workflow Variables and Tasks
  • Link Conditions    Workflow Variables  
     Assignment Task    Decision Task    Email
    Task    Lab Load Product Weekly Aggregate
    Table

20
More Tasks and Reusability
  • Event Raise Task    Event Wait Task  
     Command Task    Reusable Tasks    Reusable
    Session Task    Reusable Session Configuration

21
Worklets and More Tasks
  • Worklets    Timer Task    Control Task

22
(No Transcript)
23
(No Transcript)
About PowerShow.com