DSXchange

Hi, Check whether you are setting Null to stage variable,if yes please change it. Regards Boss Hi Friends, I have installed Visual Studio 2005 express edition and Datastage v7.5x2 on Windows XP. But when i create a parallel job with a transformer I am getting the following errors while compiling. Ou...

Hi, Mutex error mainly occures while link collector stage waits for data arrival and finally fails.increase the Timeout value in job properites and re-run it Regards Boss Hi, I am working in Maintainance & support project. DS jobs are getting failed often because of Phantom error & mutex err...

Hi, Auto is not recomended always! use diffrent kind of partitions depending on the scenarios like Hash partition for key based opertaions,Entire for look-up,round robin for non-key operations etc Regards Boss When defining guidelines for enterprise developers is it best to recommend using auto part...

Hi,

Yes,U can pass parameters in UserVariable Actvity.

Regards
Boss

abha_sinha wrote:Hi
I am trying to use User Variable Activity and call a routine which will take the path and name of a file as parameter.Is it possible to pass the parameter in User Variable Activity? Thanks in advance

Hi, The best option is using stage Link Collector. Regards Boss I receive data from 3 files and I need to Funnel them and load it to a table. In parallel job it could have been done by Funnel stage. I am using server job. Please let me know how it can be done in server job. *Note: Moved to correct f...

Hi, The best option is using stage Link Collector. Regards Boss I receive data from 3 files and I need to Funnel them and load it to a table. In parallel job it could have been done by Funnel stage. I am using server job. Please let me know how it can be done in server job. *Note: Moved to correct f...

Hi, You can read XML file using sequential file also!! even folder stage can be used. But in the XML Input stage you have to meniton the X-path(hierachy) for each and every output columns and repeative column should be mentioned as key. Regards Boss :lol: I have a requirment that need to convert XML...

Hi, You can read XML file using sequential file also!! even folder stage can be used. But in the XML Input stage you have to meniton the X-path(hierachy) for each and every output columns and repeative column should be mentioned as key. Regards Boss :lol: I have a requirment that need to convert XML...

Hi Swati,

If source is flat file then resctrict records by sampling the records using cat commond.If it is a table edit source query like Fetch first 10 records. we dont ahve any option for PX jobs!.

Regards
BOSS

Hi, Use the below function Field(col1,delimeter,instance) In your case Field(col,',',1) will fetch record before comma deleimter Field(col,',',2) will fetch after comma deleimter ....................... etc Regards BOSS :roll: Hi friends, I facing a problem in splitting the string by delimiter. I ne...

Hi, If you are sure about the no. of rows in the source then it can be done easily otherwise its almost impossible! Regards Boss :roll: Hi, I've a requirement like of below, I'm reading a file where i've 2 columns (Column1 & Column2). If this file has 10 records,then i've to create 10 files wher...

Hi, In sequential file datatypes Char and Decimal are considered as fixed widht,so you have to edit metadata properites for sequential file,wherein need to give Null field value=' ' no. of spaces shoud be equal to lenght of column Regards Boss :P Hi, A Simple 'Oracle Enterprise-> Transformer -> Sequ...

Hi, Use the function Ereplace (string, substring, replacement ) In your case it would be Ereplace(Col A,',','') Regards Boss :D Hi , My input data is as follows: Col A ( Number) 1,002.03 123,002.34 1,234,002.96 How do I remove comma (,) from numbers in datastage. I know I can remove it using Unix bu...

Hi, I am calling a DS job using UNIX script ${DS_JOB} -file ${DS_LOGIN} ${DS_SERVER} -run \ -param STEPID=${STEP_ID} \ -param STAT=${STAT} \ -param DATADIR=${DATA_DIR} \ -param SSJ=${SUB_STAT_JOB} \ -wait \ -jobstatus \ -userstatus \ ${PROJECT} \ ${DS_JOB_NM} >> $LOG_FILE 2>&1 Here what DS_LOGIN...