DSXchange

It works perfectly. Thanks for the tip.

No they are both Decimal 38,10.

I know it is not the most efficient datatype, but when I do import the structure of the database table where the dataset structure is coming from, this is what Datastage do use as datatype to handle an Oracle number.

thank you for the answer.

well, the 2 datasets are partitioned and sorted on the same key. (one field only in the two datasets.)
The 2 datasets are merged on this key.

When I join the two datasets, in the other case, I still join them on the same key.

hi,
I've forgotten to say about that.
They are partitioned and sorted on the same field. (which is the "primary key")

hi, thank you for your answer. Well, I use hash partition, because these is the only one I can expect what it will do. I am not sure that others options (like round robin, Range or Random for exemple) would partition the data the same way with the two datasets, because round robin will paritition co...

if you are in the hurry, not in easy feeling with datastage, and if you are using Oracle database (at least 9i version) , you can use the analytic functions of the database in the oracle stage : with TEMP as ( select country, region, myProduct, sum(price*quantity) over (partition by country, region,...

DATASET_1_______ DATASET_2_______ |MERGE|---->output Here is a simple shcema of my job. I've got 667 000 lines in dataset_2 and 28 millions in dataset_1. There is no duplicate data in the two datasets. I use a hash partition option , set on the common primary key. The job runs with 4 nodes. I want ...

thank you for your answer. my boss doesn't like me using routines for some security reasons he says. So I would rather like not using it but if it is the only way... it's a pity there is not such a basic function shipped with datastage. So i guess, I'll get the same problem for regular expressions. ...

on a UNIX machine, with PX server (v8.01) For example, in a field i get filePaths. but the slashes are twins ex : "C:\\toto\\toto1\\toto2\\toto3" in a transformerStage (on a parallel job); how can I simply replace the double slash into a simple slash like : "C:\toto\toto1\toto2\toto3&...

there is no error messages.
the designer program is locked with the "sandglass" turned on.

after ten minutes, I've no choice to kill the designer program.

By the way, as the server is restarted every friday, it seems it is ok now.

thank you for your answer.

Hi, I got a job I want to update. Usually, I do import a dsx file containing that job. But this time, it doesn't work. The import process is too long, after 15min, it does nothing (usually it lasts less than a minute) I've checked at the website administration interface about a ghost/dead connection...

Yes, I mean a sequential file

Hi, i get the same problem. I've noticed it happens when you have a csv file as input my csv file is ";"-field-separated, all fields are surrounded with quotes like this : "abc";"123";"";"e7r8t9" "abd";"123";"31/01/2000 14:58...

Hi, in 2010, it seems the problem still exists while I'm facing the same. I've imported several jobs. (the jobs were already on the server, I've imported a new version of them, overwriting the old version ) I know I'm the only one locked on it. To be sure, I've made a cleanup ressources on all my jo...

hi, I couldn't see the answer containing the code, as I'm not a premium member yet. Thanks for the link. I've found a solution , this is : CONVERT( '-', '', OCONV ( ICONV(MY_STRING_DATE, 'D4/DMY[2,2,4]')-8 , 'D-YMD[4,2,2]') ) Iconv giving conversion from string(DD/MM/YYYY) to date. Oconv giving conv...