How to get the parameter values logged?

While the parameter file is set on workflow level, the logging thereof is not. You can get the parameter values relevant to a session by setting the "Override tracing" in the "Error handling" section of the "Config Option" tab of the session properties to "Verbose init". With "Verbose data" you also get the parameter values logged, however, it is not advisable to set it unless for debugging as it writes the values of each processed record in each transformation to the log this making it explode and slow down the process to tears.

IS_DATE fails miserably in PowerCenter 10.1.1 HF

see https://network.informatica.com/message/245101

$PMWorkflowName contains worklet name

Problem (PowerCenter 10.1.1 HF1)

I wanted to use $PMWorkflowName to check within a worklet within which workflow it runs. However, it seems that it does not contain the workflow name but the worklet name. At least the check in the connector miserably fails and using it as command name shows the worklet name.

Test case

Work-around

1. Define workflow variable.
2. Assign $PMWorkflowName to the workflow variable in an assignment element.
3. Define worklet variable.
4. Assign the workflow variable to the worklet variable with a pre-worklet assignment. (This is needed only on the first level in case of cascading worklets. However, I did not test, if this is needed for later executed worklet cascades on the top level.
5. Use the worklet variable for the check in the worklet.

Precedence of variable value definition

Documentation

Test

Parameter file: global not that global

Problem

I have this mapping using two variables with persistent values which I wanted to override. So I put the desired values into the parameter file into the global section. And... nothing happened. The variable assignment did not show up in the logs.

Solution

When I put the variables into the according mapping section and everything was fine.

Throw application errors (variable/output port)

At times one whishes to throw an error on certain condition. A rather obvious way to do is in an expression by means of the ERROR() or the ABORT() function. You can do this at two locations.

1. Output port: Be aware that this only works if the outport is connected to another transformation. Unconnected output ports are not evaluated at all. Possibly, this is an efficiency measure by PowerCenter.
2. Variable port: This works also if it is no further used. Be aware that if you do not remove unused variable ports, you bloat your mapping (code). I am not aware of an efficient method of detection of unused variable ports. It would be nice if PowerCenter would only execute unused variable ports if they contained the ERROR() or the ABORT() function.

PLS-00306: wrong number or types of arguments

This is a bit a hidden one as PowerCenter does not state what exactly it is sending against the data base from a stored procedure transformation - not even with tracing set to Verbose Data.


It appears that PowerCenter sends the parameter by position not by name, and it does not support boolean data type.


This leads to following:

• You cannot have a boolean parameter in a Oracle procedure/function wanting to us it from within PowerCenter.
• You cannot take advantage of default values of parameters of Oracle procedures/functions.

You might want to write a suitable wrapper.

[PCSF_46009] Invalid type [HTML] encountered.

Knowledge base article 104262 describes what to do if you encounter this when starting up a repository or integration service on the server, but what if this happens on the client side when trying to connect to a repository? This is actually not so improbable as it might see at first.
I set up the environment variable http_proxy for frequent wget use and ran into this problem.
As the PowerCenter client ignores no_proxy variable you are screwed. You just can alter the variable name to something like _http_proxy when you connect to PowerCenter repository.

Designer colour scheme

I altered the colours of designer transformations to get a better contrast to the text/captions of them. I exported (hopefully) their registry entries, you could save to a .reg file to easily import them.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables]
"Display ToolTip"=dword:00000001
"Table Font"="MS Shell Dlg"
"Table Font Script"=dword:00000001
"CX"=dword:000000c8
"CY"=dword:00000096

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1]
"Forefround"=dword:00ffffff
"Background"=dword:0000c000
"Background2"=dword:00ffffff
"Type"=dword:00000001

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_0]
"Type"=dword:00000002
"CX"=dword:00000012

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_1]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_2]
"Type"=dword:00000003
"CX"=dword:00000028

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_3]
"Type"=dword:00000004
"CX"=dword:00000028

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_4]
"Type"=dword:00000005
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_5]
"Type"=dword:00000001
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_1\Column_6]
"Type"=dword:00000006
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_10]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:0000000a

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_10\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_10\Column_1]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_10\Column_2]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_100]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_101]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_102]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_103]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_104]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_105]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_106]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_107]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c000
"Background2"=dword:00ffffff
"Type"=dword:0000000b

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_3]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_4]
"Type"=dword:00000005
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_11\Column_5]
"Type"=dword:00000006
"CX"=dword:00000046

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_12]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:0000000c

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_12\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_12\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_12\Column_2]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_12\Column_3]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_13]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_14]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:0000000e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_14\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_14\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_14\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_14\Column_3]
"Type"=dword:00000004
"CX"=dword:00000046

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_15]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:0000000f

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_15\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_15\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_15\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_16]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_17]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_18]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_19]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2]
"Forefround"=dword:00ffffff
"Background"=dword:00c000c0
"Background2"=dword:00ffffff
"Type"=dword:00000002

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2\Column_0]
"Type"=dword:00000002
"CX"=dword:00000012

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2\Column_1]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2\Column_2]
"Type"=dword:00000003
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2\Column_3]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_2\Column_4]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_20]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_21]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_22]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_23]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_24]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_25]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26]
"Forefround"=dword:00000000
"Background"=dword:00c0c0c0
"Background2"=dword:00ffffff
"Type"=dword:0000001a

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26\Column_1]
"Type"=dword:00000001
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26\Column_2]
"Type"=dword:00000002
"CX"=dword:00000032

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26\Column_3]
"Type"=dword:00000003
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_26\Column_4]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_27]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_28]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_29]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_3]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000003

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_3\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_3\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_3\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_30]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31]
"Forefround"=dword:00800000
"Background"=dword:00f0caa6
"Background2"=dword:00ffffff
"Type"=dword:0000001f

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31\Column_0]
"Type"=dword:00000002
"CX"=dword:00000012

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31\Column_1]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31\Column_2]
"Type"=dword:00000003
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31\Column_3]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_31\Column_4]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_32]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_33]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34]
"Forefround"=dword:00000000
"Background"=dword:00c0dcc0
"Background2"=dword:00ffffff
"Type"=dword:00000022

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34\Column_0]
"Type"=dword:00000002
"CX"=dword:00000012

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34\Column_1]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34\Column_2]
"Type"=dword:00000003
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34\Column_3]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_34\Column_4]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_35]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_36]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_37]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_38]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_39]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_4]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000004

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_4\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_4\Column_1]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_4\Column_2]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_40]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_41]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_42]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_43]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_44]
"Forefround"=dword:00ffffff
"Background"=dword:00ffc0c0
"Background2"=dword:00ffffff
"Type"=dword:0000002c

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_44\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_44\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_44\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_45]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:0000002d

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_45\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_45\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_45\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_46]
"Forefround"=dword:00ffffff
"Background"=dword:00c08000
"Background2"=dword:00ffffff
"Type"=dword:0000002e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_46\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_47]
"Forefround"=dword:00ffffff
"Background"=dword:00c08000
"Background2"=dword:00ffffff
"Type"=dword:0000002f

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_47\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_48]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_49]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_5]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:00000005

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_5\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_5\Column_1]
"Type"=dword:00000001
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_5\Column_2]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_5\Column_3]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_50]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:00000032

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_50\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_50\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_50\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_51]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_52]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_53]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_54]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_55]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000037

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_55\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_55\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_55\Column_2]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_55\Column_3]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_56]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000038

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_56\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_56\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_56\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_57]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_58]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_59]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_6]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c000
"Background2"=dword:00ffffff
"Type"=dword:00000006

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_6\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_6\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_6\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_6\Column_3]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_60]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_61]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_62]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_63]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_64]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_65]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_66]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_67]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_68]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_69]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_7]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000007

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_7\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_7\Column_1]
"Type"=dword:00000002
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_7\Column_2]
"Type"=dword:00000003
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_70]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_71]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_72]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_73]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_74]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_75]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_76]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_77]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_78]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_79]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_8]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:00000008

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_8\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_8\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_8\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_8\Column_3]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_80]
"Forefround"=dword:00ffffff
"Background"=dword:000000c0
"Background2"=dword:00ffffff
"Type"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_80\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_80\Column_1]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_80\Column_2]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_80\Column_3]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_81]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_82]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_83]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_84]
"Forefround"=dword:00ffffff
"Background"=dword:0000c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000054

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_84\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_84\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_84\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_85]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_86]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_87]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_88]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_89]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c0c0
"Background2"=dword:00ffffff
"Type"=dword:00000009

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9\Column_1]
"Type"=dword:00000001
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9\Column_2]
"Type"=dword:00000002
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9\Column_3]
"Type"=dword:00000003
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_9\Column_4]
"Type"=dword:00000004
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_90]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_91]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_92]
"Forefround"=dword:00ffffff
"Background"=dword:00c0c0c0
"Background2"=dword:00ffffff
"Type"=dword:0000005c

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_92\Column_0]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_92\Column_1]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_92\Column_2]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_93]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_94]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_95]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_96]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97]
"Forefround"=dword:00ffffff
"Background"=dword:00f0caa6
"Background2"=dword:00808080
"Type"=dword:00000061

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97\Column_0]
"Type"=dword:00000005
"CX"=dword:00000012

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97\Column_1]
"Type"=dword:00000000
"CX"=dword:00000064

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97\Column_2]
"Type"=dword:00000001
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97\Column_3]
"Type"=dword:00000002
"CX"=dword:0000001e

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_97\Column_4]
"Type"=dword:00000004
"CX"=dword:00000050

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_98]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Tables\Table_99]
"Forefround"=dword:00ffffff
"Background"=dword:00000000
"Background2"=dword:00000000
"Type"=dword:00000000

1:1 put through ports in aggregator

What value is put forward in 1:1 put-through ports of aggregators?

It's the value of the last record of the group coming along. E. g:

Input (order matters!)

Group-by-column	Non-group-by-column
1	A
1	B
1	C
2	c
2	a
2	b

Output:

Group-by-column	Non-group-by-column
1	C
2	b

Parameter cascading variable assignments

I strongly feel that it is NOT possible to cascade variable assignements using user defined variables/parameters (the ones with the double $ at the beginning)

The following two samples fail with an error on recursion.

$$DATE_FORMAT=YYYY-MM-DD
mplt_TEST.$$DATE_FORMAT=$$DATE_FORMAT

mplt_TEST.$$DATE_FORMAT=YYYY-MM-DD
$$DATE_FORMAT=mplt_TEST.$$DATE_FORMAT

The following does not throw an error when variable assignment is carried out but the assignment is done literally.

$$DATE_FORMAT=YYYY-MM-DD
mplt_TEST.$$MPLT_DATE_FORMAT=$$DATE_FORMAT

So the variable/parameter contains the literal string

$$DATE_FORMAT

I, however, could assign "built in" variables/parameters (the ones with the single $ at the beginning) to user defined ones. Sometimes the last part of the "built ins" can be chosen freely why I put built in in quotation marks.

Expression/Query editor warped

First of all, many thanks to Rajesh for his post giving the solution for 8.6.1. I shamelessly copied the symptom images to save time. However, I was not able to leave him an according message there.

Symptom

I work with PowerCenter 9.1.0 Hotfix 1 and at times my expression and query editors get warped. It looks like this.

Unlike Rajesh I did not experience the right hand side of getting lost which might look like this.

Solution

You can either wipe your regestry completely with the side effect of having to enter repositories and such again.
Or, you fix your registry. I recommend you to back up your registry beforehand. You have to 0 out the positions of the editors and their splitter. Apparently, it is not at the same place in the registry as in 8.6.1 (Rajesh's solution).
Then, it looks like this.

If you backup your fixed registry setting for that spot, you can import it, if it happens again and are done quite easily.
For PowerCenter 9.0.1, you could save the following into a .reg file to import it when ever you want.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\9.1.0\Designer\Options\Global\Editor\SQL]
"Keywords"="pmkeywd.ini"
"Chroma"=dword:00000001
"Extra word chars"=""
"Comment"="0,0,0"
"Keyword"="0,0,255"
"Quote"="255,0,0"
"SQuote"="255,0,0"
"Default Text"="0,0,0"
"Background"="255,255,255"
"Comment Start 1"=""
"Comment End 1"=""
"Comment Start 2"=""
"Comment End 2"=""
"SQL Editor Font"="Courier New"
"Expression Editor Font"="Courier New"
"SQL Editor Font Script"=dword:00000000
"Expression Editor Font Script"=dword:00000000
"Case"=dword:00000000
"Tab size"=dword:00000008
"Show tabs"=dword:00000000
"Expression Editor Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
  00
"Expression Editor Splitter Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,\
  00,00,00,00
"SQL Editor Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00
"SQL Editor Splitter Position"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
  00,00
"Base Editor Position"=hex:98,00,00,00,0f,00,00,00,ec,03,00,00,1b,03,00,00

Joiner XYZ must have exactly two inputs.

Symptom

You get the error even if  your mapping joiner has exactly two inputs but at least one of them is a mapplet.

Reason (possible)

I do not know for what reason Informatica made this restriction.
I imagine the OUTPUT transformation to be sort of a virtual transformation, a placeholder as the mapplet transformation is. If you imagine the mapplet in the mapping being replaced by the content of the mapplet (like you can choose in the debugger) WITHOUT the OUTPUT transformation, you end up with more than two inputs for the joiner.

Solution

Create a collector expression as only input to the mapplet output.

Uselessness of set variable functions

The setting of the new value of a mapping variable is only at the closing of the session done such that one cannot use mapping variable to provide values between target load groups.
Also, it is not possible to use the mapping variable with the new value later in the same target load group. There, however, you just can forward the port of the set variable function as it returns the new value.

Session Log File directory = $PMSessionLogDir/$PMWorkflowName/ and the like do not work

Yeah, you cannot use all built-in variables/parameters for the log file configuration, even though they are known at the time of initialisation and could be set. Why is not clear to me but apparently they are not yet set then.

Load delimited file but from a certain row on, input is garbled

Problem

You load a delimited file but from a certain row on, loaded input is garbled i. e. there seems to be an offset. Possibly this also leads to an crash of the session.

Cause

You probably have at least one text field that contains a line break as its content. The content is within quotes but none the less it does not work. By default (at least up to 9.6) PowerCenter interpretes a line break as the break for a new record no matter what the quoting is.

Solution

There is a custom property called

MatchQuotesPastEndOfLine

If set to

yes

it makes PowerCenter respect quoting of text fields over linebreaks.
You can activate this property either on session level

or as Integration Service property for all sessions at once. For the time being I do not have permissions to the admin console so I cannot provide a screen shot but we did that at my last employer's project.

Sources

• Importing Flat Files with Newline Characters in Informatica
• How to ignore new line characters fom the string while loading to csv file?? 

Workflow fails to start with "Error in expanding variable parameter"

Symptom

When trying to start a workflow in the workflow manager, you get in the integration service pane at the bottom:

Error in expanding variable parameter Please check the Integration Service log for more information.

Cause

You have a parameter file and tried to do sort of a self assignment like

$PMSourceFileDir=$PMSourceFileDir/some/path

Cure

Programming language usually support such things but PowerCenter parameter do not. Create a work around.

A mapping did not load any data containing an SQL override in a source qualifier using a mapping variable as filter

First, I know the setup is cheap. This project has the segregation of environments for DEV, INT and TEST made by differently named workflows in the same folder of the same repository... and we use mapping variables to store the highest ID having been loaded and to detect the records still to be loaded. Not obvious to me, the value of the mapping variable stored the repository is not saved per mapping but at most per folder maybe even per repository. I did not test. Being aware of that, it explains the problem described in title. The "failing" mapping did not load anything because it is the INT mapping using the stored value of the variable stored by DEV/TEST. So, if the source is the same (and it is) you have loaded everything already in DEV/TEST and the detection of records to load fails miserably.

Things learned

• Do not be too cheap
• Do not use mapping variables to detect whether rows have been loaded already or not. (This is not necessarily restartable anyway.)

Rank Transformation is spezial filter (I want the top BLUPP of the groups BLÖRTZ of the data)

A colleague of mine asked me about the working of the rank and I had to admit I did not know much about it. I just did not use it and might get using it more often instead of some more or less complicated sort, aggregate and filter conjunction. However, we tried it out a bit. Here our findings

• It is not just a ranking thing but it almost always filters!!! Number of Ranks property controls this. From each defined group, it returns as many rows as it is defined here. Again, rows not ranks as the name suggests. I.e. if you set it to 1 (well, this is the default) and in one group there are several records with rank 1, you will still get only one of those, probably just the first one happening to get identified as rank 1. To, hopefully, switch off filtering, set the number of ranks to its maximum value (for version 9.1: 2147483647)
• You control the grouping by the ticks in the Group by column of the ports tab. You can group over several ports.
• Obviously, you need to have a sort criterion. This is controlled by the R column of the ports tab. Surprisingly, you can rank over one port only. That is, if you need to sort over several ports, you'll have to compound/concatenate them beforehand into a sorting/ranking port.
• The Top/Bottom property tells the sorting order, i. e. Top means descending, Bottom means ascending.

Automagic Port Insertion into Expression (if I only knew earlier)

I just discovered that PowerCenter inserts a missing port into an expression by itself.


I had this expression where I had to calculate a big number of out ports. So I drag-and-dropped (dnded ;-) ) them to the expression and made them out ports only. After that I dnded the source ports to the expression but I did not get them all as it turned out.



After that I copied the calculations from my specification document into the expression field of the out port.



And the missing port was there as in port only.



It's magic, it's cool, I'm excited. I will see if I can remember and make use of this features.