HI *,
my problem: I've got a working mapping and try to improve performance. There is a table in my staging area, which is basicly needed only for this mapping. So I've switched it to
temporary table:
create GLOBAL TEMPORARY table staging_table ......
ON COMMIT PRESERVE ROWS;.
And the performance is fine - the loading time reduced to 60%.
.
BUT, I've got a lookup in my mapping, wich retriews date from my staging_table. But this table is empty.
REASON - a lookup creates a NEW SESSION in Oracle.
HELP. Iw would like to keep my staging table as temporary (performance !!!) but I need my lookup also.
Is there a possibilty to tell the lookup, not to opena a new session.
akotmaale
my problem: I've got a working mapping and try to improve performance. There is a table in my staging area, which is basicly needed only for this mapping. So I've switched it to
temporary table:
create GLOBAL TEMPORARY table staging_table ......
ON COMMIT PRESERVE ROWS;.
And the performance is fine - the loading time reduced to 60%.
.BUT, I've got a lookup in my mapping, wich retriews date from my staging_table. But this table is empty.
REASON - a lookup creates a NEW SESSION in Oracle.
HELP. Iw would like to keep my staging table as temporary (performance !!!) but I need my lookup also.
Is there a possibilty to tell the lookup, not to opena a new session.
akotmaale