DSXchange

Partitioning will help in certain aspects but unnnecsessary partitioning degrades the performance of jobs. In addition to what Ray,thomsonp and others have said that you need to do proper partitioning in Remove duplicate and sort stages as well. In the case of lookup leave the partitioning as auto o...

First of all why have you removing lookup stage to a join stage for performance improvement because lookup always give better performance to join.

dsusr

Just check with what version of g++ compiler you have compiled the c++ code. Because this problem comes because of incompatibility of the c++ compiler version.

Also just compile the c++ code using g++ -c <C file>.

dsusr

Nripendra Chand wrote:I'm using a transformer already, so i'll pad spaces there only.

-Nripendra

Hi Nripendra,

Check for the value of $APT_STRING_PADCHAR in environment variables. By default it must be 0x00 so just change it to 0x20 and then just try to tun the job.

Regards,
dsusr

First check that plug-in is installed at your server. Because it might be visible to you in the canvas but there may not be any operator for this stage on the server.

dsusr

Sounds like they've changed the message (I've been on a 7.0 site for a couple of weeks). Has anyone had a response from support provider about what might cause this? If it occurs because of client licensing, you (the administrator) can check the DS_LICENSE table to see which client machines are act...

Hi " When I am running a job I get below error : ACCESS DENIED: Project currently locked. The project is currently locked by Administrator. Try again or see your Administrator " Does anyone has an idea why this error comes. regards Murali Hi Murali, There can be many reasons for getting t...

Mandatory if the manual is to be believed. I believe it so have always key partitioned and sorted Join stage inputs. Perhaps you'd like to try without, and let us know the result? Runs well on two un-sorted sequential files, auto partitioned no sort. So, is something wrong with the manual and .... ...

Hi, We are having two different groups of users 'usrgp1' and 'usrgp2' and have two different projects 'usrproj1' and 'usrproj2'. We want that only the users of usrgrp1 have access to usrproj1 and usrgrp2 have access to usrproj2. We have tried all the options that are given in all related posts but t...

Hi All, I want to know can we read the decimal data in exponential form like 1.7088E7.. in datastage where source column is defined as decimal. I defined the above column as decimal as we are using this values in calculations Just try to use the data format double and since datastage normally write...

The stage you are trying to use is a plugin stage and it appears this stage is not installed on your server.

First install the plugin and follow the steps given in the plugin documentation to configure this stage.

Regards
dsusr

Hi Arun,

This happens because sequential file will not write any record if any of the column is coming null. Please check the log to see if any of the fields are coming null or just set Null Field Value property of sequential file.

Regards,
dsusr

Have you checked the hosts files on all systems? How exactly is name to IP address resolution performed? Hi Ray, Yes in the hosts file the host name is mapped to correct ip address. If i try to login on the server using rsh and hostname it is able to login on the server. Also the error is coming fo...

Hi dsusr, May i know where can we use the environmental variable in transformer. -Kumar Hi Kumar, We are doing what vmcburney has said i.e. we have defined some project level parameter and when we try to use them in transformer by taking them as job parameter then it is giving an error. The reason ...

firstly,make sure rsh service has been started. secondly,add .rhosts file into dsadm home directory on each machine, and add user dsadm in .rhosts file. thirdly, test rsh whether connected or not. Hi daniel/Ray, Pardon me for replying late. Yes I have tested for the rsh from both the servers and ev...