Test
Dienstag, 19. September 2017
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.Mittwoch, 28. Juni 2017
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.
- 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.
- 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.
Montag, 15. Mai 2017
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:
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.
Dienstag, 28. März 2017
[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.
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
Freitag, 24. März 2017
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 |
Abonnieren
Posts (Atom)