Hello,
I’m using BO Data Integrator 11.5 with an Oracle 10g.
In order to update tables, I use Merge statements in the “Load Trigger” tab in the table options.
These statements look like this:
MERGE INTO D_STEP trg USING
(SELECT [STEP_KEY] AS stepkey,
[STEP_ISN] AS isn
{STEP_NAME} AS stepname,
[STEP_LEVEL] AS steplevel
FROM dual) src
ON (trg.STEP_ISN = src.isn ) WHEN MATCHED THEN UPDATE SET
trg.STEP_NAME = src.stepname, trg.STEP_LEVEL = src.steplevel
WHEN NOT MATCHED THEN INSERT
(trg.STEP_KEY, trg.STEP_NAME, trg.STEP_LEVEL)
VALUES (src.stepkey,src.isn,src.stepname, src.steplevel)
STEP_KEY and STEP_ISN is of type decimal, STEP_NAME is varchar2 and STEP_LEVEL is int.
The problem is:
The statement that is created looks like this:
MERGE INTO D_STEP trg USING
(SELECT ‘10’ AS stepkey,
‘200’ AS isn,
‘Anton’ AS stepname,
5 AS steplevel,
FROM dual) […]
So the decimals are interpreted as char. This results in a lack of performance, because of the type vonversions. Why? I didn’t use curly braces.
What can I do?
Greetings,
Sebastian
SebastianD 
(BOB member since 2009-09-15)