Notesale: Turn your study into money

Document Preview

Extracts from the notes are below, to see the PDF you'll receive please use the links above

---

Connecting Mapping Objects
After you add and configure source, target, and transformation objects in a mapping, complete the
mapping by
connecting the mapping objects
...
Data passes into and
out of a
transformation through the following ports:
¨ Input ports
...

¨ Output ports
...

¨ Input/output ports
...

Every source instance, target instance, mapplet, and transformation contains a collection of ports
...

¨ Targets receive data, so they contain only input ports
...

¨ Transformations contain a mix of input, output, and input/output ports, depending on the transformation
and its
application
...

¨ Follow logic of data flow in the mapping
...

- The originating port must be an output or input/output port
...

¨ You must link at least one port of an input group to an upstream transformation
...

¨ You can link ports from one active transformation or one output group of an active transformation to an
input
group of another transformation
...

¨ You cannot connect more than one active transformation to the same downstream transformation or
transformation input group
...

¨ You can link ports from two output groups in the same transformation to one Joiner transformation
configured
for sorted data if the data from both output groups is sorted
...
When you drag from one port to another, the
Designer
creates a connection
...

You can also link multiple ports at the same time
...
The Designer links the ports, beginning with the top pair
...

To use the Workflow Generation Wizard:
1
...
Then, select Mappings >
Generate Workflows
...

2
...
Click Next
...
Specify the Integration Service, connection settings, and the workflow and session name prefix
...
To change a connection object, click in the connection object field
...

To change the filename for a flat file, edit the file name in the connection object field
...
Click Next
...
Change the workflow name, session name, or Integration Service
...
Click the configure button to configure connection settings
...

Properties
Configure source and target session properties
...

9
...

10
...


Mapping Parameters
A mapping parameter represents a constant value that you can define before running a session
...

When you use a mapping parameter, you declare and use the parameter in a mapping or mapplet
...
The Integration Service evaluates all references to the
parameter to
that value
...
Instead of creating a separate mapping for each customer account, you can create a
mapping
parameter to represent a single customer account
...
Before running the session, you enter the value of the parameter in the
parameter file
...
Or, you can create a parameter file for each
customer
account and start the session with a different parameter file each time using pmcmd
...

When you want to use the same value for a mapping parameter each time you run the session, use the
same
parameter file for each session run
...

¨ Create a different parameter file and configure the session to use the new file
...
The Integration Service uses the parameter
value in
the pre-session variable assignment
...


Mapping Variables
Unlike a mapping parameter, a mapping variable represents a value that can change through the session
...

When you use a mapping variable, you declare the variable in the mapping or mapplet, and then use a
variable
function in the mapping to change the value of the variable
...
At the end of a successful session, the
Integration
Service saves the final value of the variable to the repository
...
To override the saved value, define the
start value
of the variable in a parameter file or assign a value in the pre-session variable assignment in the session
properties
...
For example, the customer accounts in
the
mapping parameter example above are numbered from 001 to 065, incremented by one
...
In the mapping, use a
variable
function to increase the variable value by one
...
At the end of the session, it increments the variable by one and
saves that
value to the repository
...
It also increments the variable value so the next session extracts and looks up
data for
customer account 003
...
Create a Mapping Parameter
You can create mapping parameters for any mapping or mapplet
...
Once declared, use the parameter in the mapping or mapplet
...
In the Mapping Designer, click Mappings > Parameters and Variables
...

2
...

3
...
You can create and manage
userdefined
functions with the PowerCenter transformation language in the Designer
...
Userdefined
functions are available to other users in a repository
...
You can create a user-defined function
named
RemoveSpaces to perform the LTRIM and RTRIM functions
...
REMOVESPACES(LAST_NAME)
The user-defined function name is prefaced by :UDF
...
It is the argument
of the

Steps to Create a User-Defined Function

Use the following procedure to create a user-defined function
...
Click Tools > User-Defined Functions > New
...

2
...

3
...

4
...

You can enter up to 2,000 characters
...
Create arguments for the user-defined function
...

6
...

7
...

The Designer assigns the datatype of the data the expression returns
...
Create breakpoints
...

2
...
Use the Debugger Wizard to configure the Debugger for the mapping
...
When you create a debug session,
you
configure a subset of session properties within the Debugger Wizard, such as source and target location
...

3
...
Run the Debugger from within the Mapping Designer
...
The Integration Service initializes the Debugger and runs
the
debugging session and workflow
...

4
...
While you run the Debugger, you can monitor the target data, transformation
and
mapplet output data, the debug log, and the session log
...
View messages from the Debugger
...
View target data
...
View transformation data
...
Modify data and breakpoints
...
You can also modify
breakpoint information
...
You can copy

breakpoint information and the Debugger configuration to another mapping
...


1
...

2
...

3
...


4
...


Active Transformations
An active transformation can perform any of the following actions:
♦Change the number of rows that pass through the transformation
...
All multigroup transformations are active because they might change the number of rows that pass through
the transformation
...
For example, the Transaction Control transformation is
active because it defines a commit or roll back transaction based on an expression evaluated for each
row
...
For example, the Update Strategy transformation is active because it flags
rows for insert, delete, update, or reject
...


Aggregator
Application Source
Qualifier
Custom
Data Masking

Active/
Connected
Active/
Connected
Active or
Passive/
Connected
Passive
Connected

Performs aggregate calculations
...

Calls a procedure in a shared library or DLL
...


Expression
External Procedure

Filter
HTTP
Input
Java
Joiner
Lookup

Normalizer
Output
Rank
Router
Sequence Generator
Sorter

Passive/
Connected
Passive/
Connected
or
Unconnecte
d
Active/
Connected
Passive/
Connected
Passive/
Connected
Active or
Passive/
Connected
Active/
Connected
Passive/
Connected
or
Unconnecte
d
Active/
Connected
Passive/
Connected
Active/
Connected
Active/
Connected
Passive/
Connected
Active/
Connected

Source Qualifier

Active/
Connected

SQL

Active or
Passive/
Connected
Passive/
Connected
or
Unconnecte
d
Active/
Connected
Active/
Connected
Active or
Passive/
Connected
Active/
Connected
Active/
Connected
Active/
Connected

Stored Procedure

Transaction Control
Union
Unstructured Data
Update Strategy
XML Generator
XML Parser

Calculates a value
...


Filters data
...

Defines mapplet input rows
...

Executes user logic coded in Java
...

Joins data from different databases or flat file
systems
...


Source qualifier for COBOL sources
...

Defines mapplet output rows
...

Limits records to a top or bottom range
...

Generates primary keys
...


Represents the rows that the Integration Service
reads from a relational or flat file source when it
runs a session
...

Calls a stored procedure
...

Merges data from different databases or flat file
systems
...

Determines whether to insert, delete, update, or
reject rows
...

Reads XML from one input port and outputs data
to one or more output ports
...


When you build a mapping, you add transformations and configure them to handle data according
to a business purpose
...
Create the transformation
...

2
...
Each type of transformation has a unique set of options that you
can configure
...
Link the transformation to other transformations and target definitions
...


To create a transformation:
1
...

2
...
In the Mapplet Designer, open or create a
Mapplet
...
On the Transformations toolbar, click the button corresponding to the transformation you want
to create
...

4
...


Entering Port Names into an Expression
For connected transformations, if you use port names in an expression, the Designer updates that
expression when you change port names in the transformation
...

Later, if you change the Date_Promised port name to Due_Date, the Designer changes the
Date_Promised port name to Due_Date in the expression
...

Adding Comments
You can add comments to an expression to give descriptive information about the expression or to
specify a valid URL to access business documentation about the expression
...

♦To add comments in the dialog box, click the Comments button
...
If you do not validate an expression, the Designer
validates it when you close the Expression Editor
...
You can save the invalid expression or modify it
...

Expression Editor Display
The Expression Editor can display syntax expressions in different colors for better readability
...
dll, installed on the system, the Expression Editor
displays expression functions in blue, comments in grey, and quoted strings in green
...
Expand the dialog box by dragging from the borders
...


Adding Expressions to a Port
In the Data Masking transformation, you can add an expression to an input port
...


Complete the following steps to add an expression to a port
...
In the transformation, select the port and open the Expression Editor
...
Enter the expression
...

3
...
use comment indicators -- or //
...
Validate the expression
...


You can configure variables in transformations to store data from source rows
...

For example, a source file contains the following rows:
California
California
California
Hawaii
Hawaii
New Mexico
New Mexico
Each row contains a state
...
Configure a variable in the Aggregator transformation to store the
row count
...
New Mexico
New Mexico,3



---