Recent content by akotmaale

Hi, I try to use range partition in my session. So I've added 4 partitions with start value and end value. And I've ran my workflow. I was surprised. I've got my data muliplied with 4. Funny. Then I found out, there is a possibilty to customize the query in the transformationa tab. So I've...

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...

Hi, it isn't.Because the input of my stored procedure is the min and max values of the filter. and my procedure should disable idexes for partition that are within this two values. So the first thing is to disable this indexes and the second to load data. But in the designer that is parallel...

Hi, i need some help. I've got a complex mapping and just before the target Definition there is a filter. What i want to do is: parallel to this filter-target_definition connection create a filter-aggregator-stored_procedure connection. The aim is: i get from this filter via aggregator max...

Thnx

thnx for your advice. Well, the problem was, that this unconnected lookup was not in mapping designer area. I thought that it is enough to create a valid unconnected lookup and then just use it in transformation with this :lkp.lookup_name(params) notation. But I have another question: this...

hi, i've created a unconnected lookup. I suppose it is fine. There is an input port, lookup port and return value. Input and lookup is a decimal number. I try to use this lookup in my transformation expression like this: :LKP.lkp_name(1). But I get this invalid function reference error. What...