DSXchange

ray.wurlod wrote:No. If you promote the subrecord you won't get the subrecord column AND the contents of the subrecord - you can't have both. ...

Ok but do you know a stage which could do this kind of operation ?
The documentation from ascential is not very clear about that ..

thanks

Hi everyone, I'm quite beginner in some PX Stage like "Promote Subrecord" and i have some questions : my record look like this : a,b,c,d a,e,f,g b,h,i,j b,k,l,m and i want the following result : a,b,c,d,e,f,g,h b,h,i,j,k,l,m 1) can the "Promote Subrecord" stage do this ? i guess ...

Hello, I'm trying to execute a very simple job : OCI oracle ->transformer -> sort -> OCI Oracle But during the execution, the process returned a very weird error : "Null value on accessor interfacing to field" i was thinking that DS PX was able to handle itself the "null" value f...

hello,

i'm looking for some ways to improve performance of Aggregator Stage.
But i didn't find any options to say to DS that my source is already sorted (i use an order by sql clause) like in DS 5.0 Server where there was such options (i used to use it !)

Thank you

Chanthou

the processing after the OCI is exactly the same. as i mentionned, i execute an explain plan and i tested the 2 queries oustide of Datastage, and i have the same conclusion. I think, may be, that PX execute the SQL queries with parallel oracle option and it may create some weird results. What do you...

Hello everyone !! I have a very weird problem with an Oracle OCI SQL Query. I have compared the performance of 2 queries (which do the same thing) into an Oracle OCI the first seems to be very slow (cos i executed an explain plan on it, an it returned me very bad results) the second is normaly very ...

Thanks for your answer, but finally i decided to create 2 separated jobs, one to create and one to append.

Thanks again

Hello everyone, i'm not an beginner in designing DS job, but i tried to create and append text file, but it seems that the "append" action overwrote the current first rows (from top to bottom). It's very annoying. I have to precise that there is only one source (text file), one transformer...

Hi all, i posted an answer the 06/16/2003 to Steven about a loading solution (topic : "loading performance") by using the sqlplus command : copy. So i was wondering if someone has already experimented this command and found that it's faster than DS for loading rows with a lof of columns (>...

Hi all, I discovered the same problem about the Oracle OCI. Indeed, i tried to load data into a table with 70 columns, the source is a User Sqlquery. The result is : 600 rows/s To fix this, i used the sqlplus command : copy. It's a great command because you can insert data by using a sql query and w...