DSXchange

Hi Has anyone encountered the error message: "Failed to save intermediate results" when compiling a job? It appears that this is a critical error that prevents any further saves/compiles against the mapping. The only way around we can find is to copy the mapping, delete the original and re...

Hi all I have tried manually entering the column derivations, however the parameters to be passed in (col1 and col2) can't be hard-coded (as they are read in from seq files) and I can't figure out how to pass them through as bind variables. It is interesting that there are widespread problems with i...

Thanks for the feedback Kim. The reason why I was doing a select from Dual is because I am unable to import the stored procedure definition. Whenever I try to import it, I get the following error: DSR.MetaGeta(GET.PROC.COLUMNS)(DSSQLProcedureColumns("","SIEBEL","CRMLOOKUPBRO...

Hi Apologies if this has been covered elsewhere - I have searched for it, but to no avail [:I] I need to return a string from Oracle DB (using ODBC stage) that is calculated via a user defined SQL statement that includes a function (using the key values as parameters). e.g: SELECT col1, col2, calcul...

When writing to multiple ODBC tables on the same database (Oracle), is there any performance advantage by using just 1 ODBC stage and having all links point to that stage? This can get somewhat unwieldy when 15-20 links point to the same stage. The flip side would be a dedicated ODBC stage for each ...

Thanks Ray A clever workaround and one that I hadn't considered. I had got to the point where the only possible solution I could think of was to call a PL/SQL stored procedure (that applied the lookup/logic within the container) and return the resultset back to the interface. I will certainly give y...

Ray, Many thanks for your effort and interest on this.... Your diagram was almost on the button! What I'm trying to do is: .................ODBC ...................| (ref) ...................V Inp -----> Transformer1 ---> Transformer2 ---> Out ..................................| .......................

Thanks Ray... I guess my problem is that the container contains the ODBC lookup, 2 transformers, an aggregator and an ODBC target (as well as the container output) and I can't feed the returned output back into the transformer that referenced it (transfomer only accepts 1 stream input and a referenc...

Hi As a relative newcomer to DS v6, I am having a problem with assiging Batch Numbers and RowIds to records. Any help greatfully received [:)] I have created a table (BATCH_CONTROL using Interface ID as primary key) that holds info for each DS interface mapping (e.g. Batch range,max records per batc...