DSXchange

Hi I have made a sequencer using Execute command Activity stage and i m runnig three scripts using this Job. But while compiling i m getting following errors:- Compiling: Source = 'RT_BP28/JOB.1362165032.DT.1487844563', Object = 'RT_BP28.O/JOB.1362165032.DT.1487844563' ******************************...

Hi Ray,
Thanks for ur solution, issue is resolved.. :D thanks a lot

I have simple Job Seq----> Transformer---->Db2 I have following records in source:- 31,1,1,N,206,2181365126 33,1,1,N,208,2181364446 35,1,1,N,212,2181365113 37,1,1,N,214,2181365076 38,1,1,N,215,2181364745 Sixth col is Integer data type and the file is imported successfully. But when records are trans...

My Col1 is key col. and i want to send first repeated record to output2 and rest of the records to output1 on the basis of this key col....................i have trapped this using server stage but in parallel i m getting problem.........

Hi I have record like this:- Col1 Col2 1 a 1 b 1 c 2 d 2 e 2 f I want to trap duplicate record in PX. My output1 should be like this:- Col1 Col2 1 b 1 c 2 e 2 f and Output2 should be like this:- Col1 Col2 1 a 2 d kindly help me to implement this in parallel Thanks in advance

Hi, I am getting following fatal error during job run:- buffer(0),0: Fatal Error: APT_BufferOperator::writeAllData() write failed. This is probably due to a downstream operator failure. My job design is like this:- Sequential_file----->Funnle Stage-->transformer--->db2 stage I think there is a probl...

Hi all, I am getting following fatal errors during running the job:- main_program: The section leader on CNDAIRPZDBDT03 died main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on all node...

bkumar103 wrote:No result will come out. To get the successful lookup either you convert the MEM_ID to numeric datatype or remove the leading zeors.

Even u convert MEM_ID to numeric data type it wont match the ref. data set,u have to remove leading zeros......

Hi All, During datastage restart we need to kill all active datastage cilent connections running on the server.But some of the connections takes time to close.....it goes into FIN_WAIT state...so can someone tell me the reasons for that and what are the unix commands to kill the active connections.....

Hi all
thanks a lot for ur replies.....

Hi All, I have two col as input:- col1:-depth col2:-amount and records are like this depth amount 1,10 1,20 2,20 3,30 3,40 4,100 3,100 4,50 4,50 2,200 3,200 but i want output as:- If Depth =1, then amount = amount corresponding to it ( ie depth 1)+ amount until u encounter a row with depth =1 again ...

Hi Ray,
Ya i have checked the output of Field() function with extra output link and its working fine.................................but still my output is not correct.......

Hi,

I am very sorry,it is
R=X-A
and target is sequencial file
Here i m getting 0 insted of some numaric values......

HI, I am taking input from flat file. It has three column These are:- COL NAME DataType DATE1 VARCHAR DATE VARCHAR DATE1 Contains Input as d/m/yyyy DATE Contains input as d/m/yyyy In Transformation i m applying this Logic:- Stage Variable Name A=Field(InputLink.BILL_DATE1, "/",1) B=Field(I...