DSXchange

I can think of 3 options : 1) use a server job and perform an ereplace on the derived string -- this could be a standalone job,.. if this is not practical and you are running mainly parallel jobs then 2) write a C++ routine that does the equivalent of an ereplace and use that routine in your paralle...

Ahhhh, the single quotes and correct spelling -- yes I'm a horrible typist. GetEnvironment('envVAR') WORKS. Now to move the GetEnvironment to a stagevar initial value so I only fetch the value once instead of for each row.

Resolved.

:D Thank you. Thank you. Thank you. :D

I DO pick the environment variable from the ellipses of the GetEnvironment. When I do, I can pick ANY parameter I have soecified in the Job Parameters. One of them is $envVAR. The $ is put into the ellipse as well. This does not create an invalid derivation at this time. But this DOES create the &qu...

If I code "envVAR" in the derivation is the value in the target is envVAR. I don't want envVar in the target or $envVAR in the target. I need the value of $envVAR in the target -- this value in this case is "\home". But if the DS Admin wants to change it later to have the value &...

Thanks, I just tried this and when I use GetEnvironment($envVAR), the derivation LOOKS ok, but doesn't compile. I pick the variable from the JobParameter list and it automatically puts the $ there. If I remove the $, the derivation highlights in red (invalid derivation) and still does not compile. T...

Is there a way to use the Project-defined environment variables in the transformers of a parallel job? eg $envVAR is defined as a string having a value "\home" in Administrator. In a job, in the parameters, I add the environmnt variable to the parameter list with a value of $PROJDEF. In an...

Craig, Arnd and Ray, correct me if I'm wrong, but, MLOAD locks the table for UPDATE. When the MLOAD stage from DS tries to load multiple parallel streams, it tries to run one MLOAD per (node?). 1st one gets successful lock, all subsequent nodes/data streams fail. Last I worked on a Teradata target f...

kjaouhari wrote:Thanks all , I'm using NLS map ISO8859-7-CS Seems to work fine.

So this topic is resolved?

This started in a previous post : APT_CombinedOperatorController,0: Null string argument. I think my current question, though related, is deviating from the original question so I started a new topic. Me : "(an EMPTY string; I guess this differs from a NULL string)" chulett : It most defin...

Check with support, but I beleive you have to have NLS support turned on in your installation of DS and then install multiple CODEPAGES. Fromt here, i beleive you select a default codepage for the installation, as wella project, but can choose codepage for a particular job as well. This was the way ...

see http://articles.techrepublic.com.com/51 ... 45786.html

Looks like it is the RAISERROR in SQL Server.

Thanks Craig. And I love the tag line.
But any insight into how DS is processing the derivation?

I am having a similar problem. Stage Variable Defintion populated with : If IsNull(linkname.VARIABLE_NAME) Then "000" Else If Len(Trim(linkname.VARIABLE_NAME)) <> 3 Then "000" Else If (Num(linkname.VARIABLE_NAME)) Then linkname.VARIABLE_NAME Else "000" If the incoming v...

I did indeed have a funnel after the row generator and transformer. The funnel can physically insert the row as the last one. But a subsequent stage needs the input sorted by a key field and a randomly generated value by the row generator would have then ended up in an unpredictable position. I need...

Not sure where to post this, but another solution to the vertical pivot I found was this : Use an XML Output stage, specifying your key columns and use the "aggregate rows" option in the output. You can concatenate mutliple columns into a singel row. No need for the transformer logic to bu...