DSXchange

Hi, I am using Oracle Enterprise stage in Datastage PX v7.5.1. The stage showing execution mode as sequential only while reading from the oracle 10g table. How can I make it to parallel as the execution method is set to sequential by default and not allowing me to change to parallel as it is disable...

I am using Datastage 7.5.1 on AIX server. I need to delete .ds file using unix command.

When I give the command
orachmin delete $Path/xxx.ds

it gives me an error as "ksh: orchadmin: not found".

Can you help me out in enabling the Orchadmin?

Regards,
Tushar

Hi All, I have Datastage 7.5.1 client installed on my machine. I am using UB2 as my source and hence using the DB2 enterprise stage to read the data. Earlier I was able to read the stage peoperly e.g setting up the parameter, changing the matadata etc. But suddenly it stopped working. Whenever I cli...

Hi Pongal, $PROJDEF is a default value assigned in the job parameter of any Datastage job. Now consider the scenario where administrator wants to keep some password which should not be accessed by the developer. Then in this scenario administrator can set the password for Suppose DB login in a admin...

For clearing the existing data from dataset, set the Update policy as "Overwrite" and use row generator for creating the dataset with zero row.

In Sequential file stage you have a option where you can set the first the line as column header. So DS will send the remaining data to next stage. You do not need to use unix script or transformer.

Regadrs,
Tushar

check whether your C license expired? Also check the version of C is compatible with the DS version.

But if you use the sparse look up, then process will be slower as it has to hit the database for every record. But if you use the normal lookup then it will cache all the record and then do the look up.

Hi, You can use the built in function to convert the date into number of days and from that u subtract the required no of days. For that you can use some built in function available in PX, e.g. DaysSinceFromDate or JulianDayFromDate. Once subtraction is done then convert the result into date by usin...

Hi, One approach is to Convert your date in the Integer format means if yor date is "yyyy-mm-dd" then convert it into "yyyymmdd" which is the integer and then use the max/min function. You can not aggregate on Date column as Aggregator stage converts into default dfloat before do...

What is your output stage? If it is a sequential file then while writing in the file you can specify the format as "DD-MM-YYYY". But as far as datastage is concern it will always read the date in "YYYY-MM-DD" format. hello., i am new to datastage. my inut date format is : YYYY-MM...

I would also like to know how to compile the job through the Unix prompt. Multpile job complile option is anyway GUI. But if there is option to compile the job through the Unix then we can automate the process to compile the job from UNIX if required. regards, tushar Muliple job compile options is a...

Hi, We had register the job maps for one of the server. Our prject contains huge no of jobs. We want to run our jobs on other server. So we exported the Job maps from old server. Now we imported the export file in New server, but the jobs were not running. If we try to create new maps on the new ser...