a course demo
TRANSCRIPT
-
8/6/2019 a Course Demo
1/33
1
Informatica
Developer Training
-
8/6/2019 a Course Demo
2/33
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
-
8/6/2019 a Course Demo
3/33
3
Architecture - Continued
Informatica Repository Manager GUI where you create or delete the folders for
users.
Is the GUI where the Test, Development or ProdServers are created
Usually used by Admins
Informatica Integration Server An Integration Service which integrates all your
components
One Integration Service will be connected to OneRepository Server
-
8/6/2019 a Course Demo
4/33
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
-
8/6/2019 a Course Demo
5/33
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 wecall Workflow as a Map then Sessions are
like transformations
-
8/6/2019 a Course Demo
6/33
6
Terminologies-Continued
Session Log
A Detail Log listing your execution details
Run Properties
A short version of your log listing the finalprocessing counts
Source
The Input Target
The Output
-
8/6/2019 a Course Demo
7/33
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 passingthrough them ie., Input Rows = Output
Rows
-
8/6/2019 a Course Demo
8/33
8
Source Transformation
Source Transformation are nothing but
your Input File or Table Structure
Sources can be created in the following3 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.
-
8/6/2019 a Course Demo
9/33
9
Source Qualifier Transformation
-
8/6/2019 a Course Demo
10/33
10
Target Transformation
-
8/6/2019 a Course Demo
11/33
11
Expression Transformation
Passive
-
8/6/2019 a Course Demo
12/33
12
Filter Transformation Active
-
8/6/2019 a Course Demo
13/33
13
Joiner Transformation Active
-
8/6/2019 a Course Demo
14/33
14
Aggregator Transformation - Active
-
8/6/2019 a Course Demo
15/33
15
Union Transformation - Active
-
8/6/2019 a Course Demo
16/33
16
Lookup Transformation - Passive
-
8/6/2019 a Course Demo
17/33
17
Lookup Transformation -
Continued
-
8/6/2019 a Course Demo
18/33
18
Sorter Transformation - Passive
-
8/6/2019 a Course Demo
19/33
19
Router Transformation - Passive
-
8/6/2019 a Course Demo
20/33
20
Update Strategy Transformation -
Passive
-
8/6/2019 a Course Demo
21/33
21
Sequence Generator
Transformation - Passive
-
8/6/2019 a Course Demo
22/33
22
Mapping Parameters and Variables
-
8/6/2019 a Course Demo
23/33
23
Reusable Transformation
-
8/6/2019 a Course Demo
24/33
24
Mapplet
-
8/6/2019 a Course Demo
25/33
25
Debugger
-
8/6/2019 a Course Demo
26/33
26
Workflow Variables
-
8/6/2019 a Course Demo
27/33
27
Other Tasks
-
8/6/2019 a Course Demo
28/33
28
Other Tasks
-
8/6/2019 a Course Demo
29/33
29
Other Tasks
-
8/6/2019 a Course Demo
30/33
30
Worklets
-
8/6/2019 a Course Demo
31/33
31
Other Tips and Tricks
-
8/6/2019 a Course Demo
32/33
32
Other Tips and Tricks
-
8/6/2019 a Course Demo
33/33
33
Questions