DSXchange

OK. What you need is to make sort on F1 and F2 before aggregation, which will give you correct value if function on F3 is LAST.
Depending on input, you can sort with SQL in input stage or make sort as a separate stage before aggregation.

BR Vjeran

Hi,
so it should be:

Hi,

it looks like you need max agregation on F3 column, or I am missing something?

BR Vjeran

Hi, if you don't put agregation or grouping on column F3 which value you want to transfer to next step ? eg: F1 F2 F3 --------------- 1 2 3 1 4 5 6 7 8 6 9 10 select F1, max (F2) from Table group by F1 F1 max (F2) F3 --------------------------- 1 4 3 or 5 6 9 8 or 10 ...or do you want to transfer so...

HI,

look at this topic. There is solution for NLS problem you have.
viewtopic.php?t=100188

BR Vjeran

Hi,

there is cute explanation about bulk load and inser/update problem. Probably you get good idea what to do.

viewtopic.php?t=95526&highlight=bulk+lo ... oracle+oci

BR Vjeran

Hi Ray,

it was completly "clean" installation on:
- Windows Server 2003 Standard Edition with Service Pack 1
- Oracle 10.1.0.2
- MetaStage 7.5.1 r2

BR Vjeran

Hi Jan, I have almost same problem with HASH file and QS plug in. What I have found out is following: * HASH file use code page what is in Windows server - go to DS Administrator : click on NLS... : Current ANSI code page is what DS see and use on your server - if this is not correct (eg. 1252 inste...

Hi divine, following things you must check for runing QS as DS plug-in - did you pay for RTI functionalty and did you enter license while installing DS server - did you create mngr.cfg configuration file in correct directory - when starting services first start qsserv then qsrtmngr - after that you ...