DSXchange

Hi, I have been provided with the setup of DS 7.5.1A and OS is Windows server (more details to be collected, what type of server it is) to install Datastage Server jobs alone, can i do it in the given setup and if possible what are the options that i have to set to do this activity. What i know from...

Hi Roy, Thanks for the FAQ link, it is regarding how i can add environemnt varaible and how i can use it in job level. That was informative for me. What my query here is, we find the invironment variables defined in DSParams file in the Project directory. But in that file i am not able to find for w...

Hi Roy,

But i am running a Parallel job only not a server job. That is why i have selected Job Type as Parallel.

Regards,
Rajeev Prabhu

Hi, We have installed Ascential s/w 7.5.1.A in windows NT and after that when i run a sample job it is showing the follwoing error: From previous run DataStage Job 1 Phantom 244 Program "DSD.OshInit": Line 92, Variable "SYS.LIB" previously undefined. Empty string used. Program &q...

Hi, We are given Dollar Universe [new tool created by ORSYP] to schedule and monitor the acivities of jobs. Have anyone used Dollar Universe for scheduling and monitoring DS Job, if so give me your thoughts on the same so that it will be helpful for me to understand how Dollar Universe works out for...

Hi,

Can you give me the details of what "Buidops and Wrappers" are in ETL developemnt and what is its role in Datastage or how do we use it in ETL Datastage.

Regards,
Rajeev Prabhu

Hi, I am having two files and i want to compare those files and put the output to another dataset. I have specified the key fields that are to be used to compare and have applied Hash Partitioning with the sort columns. The job is running fine but when i view the output i am getting the following er...

Hi, I am reading data from a sequentile file, with fields with two null colunms and one notnull column, to handle the null vaules i used Modify stage and in the specifications of the Modifystage i gave the expression as follows: col_1= NullToValue (col_1,'AA') col_2 = NullToValue (col_2,0) When i co...

Trim() can do it. Convert() can do it. Each works in a different way -- just depend on what you want to do. You will need to pass a hex value of the newline character in order for that to work with newline character. ("0xblah") Hi, Thankyou i will try this out. Regards, Rajeev Prabhu

If it was a Server job, I'd tell you to remove the newline in the derivation of the field by using Ereplace, for example: EReplace(YourField,CHAR(10)," ",-1,0) This would replace all newline characters in the field with a space. I'm assuming there must be something equivalent in PX so you...

Hi, We have a job which takes data from Oracle 9i stage and writes data to sequential file (It has only very small amount of data less than 20 rows). I am using Delimter as command and Quote as double and writing the data to the Seq. File. In the next job i am reading the seq. file and i was not get...

Hi, We are using 2 CPU machine HP Unix Pc and we have made 8 node configuration in the default.apt APT_CONFIG_FILE and we ran the jobs. We bulit 2 jobs, one with Transformer and one without transfomer which loads data from once source table to staging table. The job which has transformer gets aborte...

Hi, I have a column that reads data with datatype as number and in PX this datatype is converted automatically to decimal (38,10) but my target is only Number(10,2). So i want to use to Modify stage to convert one format to another, can anyone let me know how we can achive this activity in Modify st...

Hi, I am getting the follwing error when i am trying to load data with one to one mapping. I have only 2 (Oracle enterprise stage and using FAST Load method) stages in it source and staging, and both the source and staging are having the same datatype and when i run this job is am getting the follwo...

Hi, We are trying to load data from dataset to Oracle Enterprise stage, and we are doing the Truncate and Load method, and the target table is not partioned. But when the job is run i am getting a fatal error as follows: Oracle_Enterprise_1: Could not place an operator for each partition. main_progr...