topic Re: Oracle analytical functions with ELTOracle Components? in Talend Studio

Oracle analytical functions with ELTOracle Components?

Anonymous — Sat, 16 Nov 2024 10:46:38 GMT

Hello,
I am searching for a way to transform data like it is done in Oracle with analytical functions like ROWNUM.
My exact example would be a "SUM (1) OVER (PARTITION BY ID, STAT ORDER BY ID ROWS UNBOUNDED PRECEDING)".
To build such a thing in Talend i have used tSortRow -> tMemorizeRows -> tJavaRow component with Java Code to get the desired results.

My question:
Is there a way to do these things with one component or with the same code, maybe in tELTOracleMap? I tried with OracleMap but didn't found the solution because when I put the output into tELTOracleOutput I always get java.lang.NullPointerException.

Thanks,
Arno

Re: Oracle analytical functions with ELTOracle Components?

Anonymous — Wed, 02 Mar 2016 07:11:58 GMT

Hi,
tELTOracleMap component is used to graphically build the SQL statement using the table provided as input(the statement include inner or outer joins to be implemented between tables or between one table and its aliases.)

I am searching for a way to transform data like it is done in Oracle with analytical functions like ROWNUM.
My exact example would be a "SUM (1) OVER (PARTITION BY ID, STAT ORDER BY ID ROWS UNBOUNDED PRECEDING)"..

Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina