DSXchange

I think the following is taking more time in your job. 1) You create the temp table and then copy all the data to this temp table, the data seems to be large and redistribution take time. 2) delete from Table1 the records pertaining to get updated. If the two keys are giving Equal disturbution then ...

Can you please provide some more details like what is the table stucture, columns in Primary Index and what values you are updating. Seems like you are updating some column which are part of Primary Index, and it cause the row to go to another AMP which is why its taking time. Give us details about ...

Check the table defination, MLOAD update will only work if you specify the whole primary key in the Where clause else it will not work. I think A is not the only key in the Primary Index.

I want to call a routine from another routine and the name and parameters of the first routine is passed as parameter value. After Routine: FirstRoutine - SecondRoutine(0,0); ThridRoutine(0,0) INSIDE Routine fRoutine= Field(InputArg, ";", 0, 1) ; sRoutine= Field(InputArg, ";", 1,...

I have a Server job and i need to run a Shell script and DS routine after the job completes in a after job routine section; Is it possible to do this. Details: for shell script i can do this ExecSH - SheelScriptName param1 param2 for Routine i can do this RoutineName - Param1 param2 Is it possible t...

You need to ask the Unix admin to give rights to the user(the one you use to logon to Datastage) on the specified path.

I am trying to update a view through teradata Connector stage with the following settings 1) Write Mode = Update 2) Bulk Mode 3) Data Volumn (51million) 4) MissingUpdateRow = Default 5) Error1 table = ET_DWH_ARRG_CALC_VAL_Update 6) Error2 table = UV_DWH_ARRG_CALC_VAL_Update 7) Log table = LOG_DWH_AR...

I can load same table with two MLOAD streams at the same time(Server jobs), one may wait for the other but it do work. can i do same trick in TPT stage, like setting some tanacity value so that one go into sleep state while the other stream is loading into the table

Wouldn't it be nice to increase the buffer size?

I am trying to insert/update into same table using different stream using Teradata connector stage. Ristriction is i can't redesign the job i need to use multistream using Teradata connector ---------------------------------------------------------------- Teradata Connector 1) Multi stream one doing...

Hi, I am trying to do the following in Routine sFirst = '.logon server/user, password;' sSecond = 'Select Date;' sThird = '.logoff;' sFinal = sFirst : [newline] :sSecond : [newline] : sThird How can i make a string so that i can insert a newline character inb between, and then i can pass it to Terad...

Yes i have implemented the 2nd option but i thought maybe there is a way to tell DS how it create the temp table itself.

I am trying to insert/update data through a view but the problem is that when we try do multiload insert(Append mode), Datastage create a temp table with the following query Create Table TempTable AS ViewName WITH No Data; so the datastage fails that ViewName is not a table while in Enterprise stage...

I am inserting into a temp table through Teradata bulk load stage and then want to insert select into the final table but i can't specify after SQL in the stage is there any option so that we can do it. Currently i am using after routine script for insert Select after the job completes. Can anyone t...

We have contacted IBM and the patch was for one particular customer and very specific to the envirnoment they have. We still not able to make it work IBM says they don't provide support for BigInt at the moment, they will pass our request to the engineerring dept.