DSXchange

I have another piece of information that might be helpful. This column under question used to be of datatype CLOB in Oracle (from where this table was created in Netezza). However, its datatype was changed to Varchar(4000) to be compatible in DS and Netezza. Can this be a reason ? But if the table i...

hmmm... I thought so too. But how ?
And more importantly, how do I avoid it ?

I even extracted the query from the source stage and ran it at the back end. It still shows NULL there.

Hello Experts ! I have a very straight-forward mapping, with the following structure: Netezza Source ---> Transformer ---> Netezza Target I am facing a very strange situation here. A particular row has NULL value in one of the columns in the back end table. However, when i click on the "View Da...

Nopes.

Expression Type: Return Value (Conditional)
Expression: = 1



But I have a solution to the problem. Found it on the forum itself. Suppressed that warning by unchecking the "Log warnings after activities that finish with status other than OK"


Thanks for the help guys.

I'm doing exactly that.
But, in the triggers tab, I use Return Value option. if = 1 then Job1 and if = 0 then Job2.

But still, when the command executes, it gives a warning.

How ??

Hi everyone, I am facing a very strange problem. Here is my sequence design: Execute command -----return val 0---------> job1 -----return val 1---------> job2 The command stage executes a unix script which returns 0 if a file is found and 1 if it is not found (using "exit 0" or "exit ...

Hi everyone, I have a job structured like this: Orcl OCI Src ---> Transformer ---> Seq File ----> ORA Bulk Tgt I have 2 stored procedures where I drop indexes and constraints on the Tgt table before loading and then re-create these indexes after the load is complete. As of now, I call the 1st SP (to...

Reduced it and checked again. Array size is 2000 now. Kept Rows per Transaction as 0 and Prefetch memory to 1024.
The job takes 1 hr to run now.

Hey guys, First of all, apologies for re-opening a resolved thread. But I had to do it (or reference this thread in the new post) since I'm getting a very similar (actually the same) problem in another one of my jobs. Here is the job design: Oracle OCI ------> Transformer --------> Oracle OCI The so...

Thanks a lot guys. I increased the target and source array size and memory prefetch values and that did the trick. The job runs in 30 mins or so now.

Thanks again for your help.

Source Array Size: 10000 Prefetch Mem Setting: 1024 Target Array size: 1 Transaction size: 0 Rows per transaction: 0 3 months into DS and I'm looking at these numbers for the 1st time. Pardon my naivety :( But again, I'm not performing any task in the transformer. Isn't there a feature in DS which i...

Mike,
That is exactly what I want to do. But through DataStage. This is one of the steps in the entire ETL design being developed using DS. How can I achieve the thing that you mentioned (running the query on the DB itself instead of dragging data) using a DS server job ???

Oh, to clear that doubt. I ran that query with a "create table" on top of it so that I'm not viewing 500 records.

Job design !
I told you already:

Oracle OCI ---> Transformer -----> Oracle OCI

The only task that it performs is load data into the target table using the query in the source.