DSXchange

unfortunatly i couldn't read these posts because i'm a basic member , but anyway many thanks for ArndW , chulett

i'll mark the topic as resolved , for premium users


Gendy

this is the output i get : $ crontab -l 0481-103 Cannot open a file in the /var/spool/cron/crontabs directory. A file or directory in the path name does not exist. any idia ? The System parameter crontab refers to invalid path , the file is missing , so the default privillages is that each user see...

what do you mean with fork join ??

anyway there may be many reasons , the degree of parallism , i.e. partitioning and sorting methods , configration of nodes used for every job, data type and size for every job , etc .....

kinldy illustrate , and give us more information to help you


Gendy

it is not a data stage error , just use the smtp mail for the group you have , don't use the group id , example if have a group called All Staff , the you could send mails to it from outlook because it automatically resolve the smtp adress for this group and send to it ,, the smtp adress could be so...

did you try to open the log file /abc/ac/02/scratch/ora.20269.404983.0.log ,,

what did you have there ?

hi Cherry , i have a solution for your problem but it is little long first what we need here to convert rows to one row , with concatenated columns , also we may want preserve ordring 'if you nedd the output to bee AAABBB not BBBAAA' so let's go first you will need to read the data twice , i.e. the ...

Check the UNIX kernel limit on the number of processes any process can start. This is usually called something like NPROC. ... dear ray thanks a lot for your interest , i already checkd the maximum number of processes , and i can change them , but the question is , why this warninng appears only fo...

You probably got the wrong answers using Auto partitioning first i agree with what ray said , you may get wrong results using auto partitioning while you are using Hash aggregator , that propably happen with massive number of data second , why do you expected more performance when using sorting and...

you can use transformer stage first to convert null to zero in case of integer , and to empty in case of characters , then use aggregator stage to get max value for integer , and sum for characters , or you can use sum for both , try this , i think it will work

if the data contains no decimal , use integer , if it contains decimal values , use decimal or double , but i prefere double because it doesn't preserve space for the datatype like decimal , it preserve space for the value it contains , so use double without specifying size or precision

Hi all, I faced a strang behavior in the configration file , which i need to understand we are using datastage 7.5.2 on IBM AIX Server with 4 processors and 24 GB ram i've made 8 nodes pointing to the same file system , i.e. the same node and copied it 8 times with diffrent name and i have some ques...