Informatica - PowerPoint PPT Presentation

Loading...

PPT – Informatica PowerPoint presentation | free to download - id: 16349e-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Informatica

Description:

Informatica Powercenter. The GUI to develop the program logic applying the business rules ... Informatica Repository Manager. GUI where you create or delete ... – PowerPoint PPT presentation

Number of Views:220
Avg rating:3.0/5.0
Slides: 34
Provided by: polk8
Learn more at: http://www.learnersparadise.com
Category:

less

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

Title: Informatica


1
Informatica
  • Developer Training

2
Architecture
  • Informatica Powercenter
  • The GUI to develop the program logic applying
    the business rules
  • Informatica Workflow Manager
  • The GUI to setup the sessions to execute the
    program logic
  • Informatica Workflow Monitor
  • The GUI to monitor the scheduled or executing
    jobs
  • No Development is done here

3
Architecture - Continued
  • Informatica Repository Manager
  • GUI where you create or delete the folders for
    users.
  • Is the GUI where the Test, Development or Prod
    Servers are created
  • Usually used by Admins
  • Informatica Integration Server
  • An Integration Service which integrates all your
    components
  • One Integration Service will be connected to One
    Repository Server

4
Terminologies
  • Map
  • Component containing all your business logics
    coded to achieve the desired output
  • Transformation
  • Also called as Instance. An individual step in
    your map. Each Transformations are unique by its
    nature and their capabilities
  • Ports
  • Individual Fields in the Transformation. These
    fields relate to the Input or output Columns of
    data

5
Terminologies-Continued
  • Session
  • A executable component to execute the Map. A
    session contains your input and output details
    along with any database used within the Map
  • Workflow
  • A Collection of one or more Sessions. If we call
    Workflow as a Map then Sessions are like
    transformations

6
Terminologies-Continued
  • Session Log
  • A Detail Log listing your execution details
  • Run Properties
  • A short version of your log listing the final
    processing counts
  • Source
  • The Input
  • Target
  • The Output

7
Terminologies-Continued
  • Active Transformation
  • Transformations which increase or decrease the
    number of rows when the data are passed through
    them
  • Passive Transformation
  • Transformations that doesnt make any changes to
    the count of the rows passing through them ie.,
    Input Rows Output Rows

8
Source Transformation
  • Source Transformation are nothing but your Input
    File or Table Structure
  • Sources can be created in the following 3 ways
  • Import from the File in case of a Flat File
    (Text Files, CSV Files, .DAT Files etc)
  • Import from Database in Case of a Table
  • Create Manually.

9
Source Qualifier Transformation
10
Target Transformation
11
Expression Transformation Passive
12
Filter Transformation Active
13
Joiner Transformation Active
14
Aggregator Transformation - Active
15
Union Transformation - Active
16
Lookup Transformation - Passive
17
Lookup Transformation - Continued
18
Sorter Transformation - Passive
19
Router Transformation - Passive
20
Update Strategy Transformation - Passive
21
Sequence Generator Transformation - Passive
22
Mapping Parameters and Variables
23
Reusable Transformation
24
Mapplet
25
Debugger
26
Workflow Variables
27
Other Tasks
28
Other Tasks
29
Other Tasks
30
Worklets
31
Other Tips and Tricks
32
Other Tips and Tricks
33
Questions
About PowerShow.com