DSXchange

thanks ray,is there any other way to kill DS related PIDS ,as if it is necessary to kill

when do we get such kind of error

ZUNIQID_lkp,1: sendWriteSignal() failed on node iocl21p1 ds = 21 conspart = 0 Broken pipe

I have built a build op stage which has one output link and a reject link. To transfer records to reject link i have used dstransfer()macro in my code and so falsed out the Auto transfer option Under Transfer tab. But when i did this i got the below error. Operator Generation Failed buildop -f -BC /...

:!: Modify stage uses zero-based counting. Nothing wrong with Transformer stages (these days) either. I can get this funtionality using transformer. But i want to know the functionality of column import. Will it split the data if the data doesnt have any delimiters. Just learning the functionlaity ...

i have the data like Field1 aaaaaaa bbbbbbb cccccccc ddddddd eeeeeee. Now i have to split this field1 to field 2 and filed 3 where filed2 should contain the 1st 3 chars and field3 should contain the last 4 chars. I can do this using a transformer. But i wish to use column import. Can i split the rec...

i got error ,which dont have any idea,help me out pls,these r the fatal thrown APS_DB_REMAINING_JOIN_INDICATORADD_tras,10: dspipe_wait(3019222): Writer timed out waiting for Reader to connect. APS_DB_REMAINING_JOIN_INDICATORADD_tras,10: The runLocally() of the operator failed. [api/operator_rep.C:40...

I don't know that there's an advantage one over the other. It's really driven by the business requirement - do you need to keep ranges of keys contiguous? If not, prefer hash or modulus for a key-based partitioning algorithm; there's no pre-processing required for either of these. Thanks a lot. I g...

ray.wurlod wrote:No.

what is the distinct feature of Range partioning when compared to hash partioning. Both offer same functionality and moreover range partitioning needs preprocessed data. What will be the best scenario where we use range partition over hash

why do we need to use this stage( range partitioning). we can get the same functionality using the hash partitioning. Also cant we force the job to put specified key values in one partition and the rest in other? When we say hash partioning related data will stay on same partition but what i want is...

i have searched about this stage and after going through the explanations , still i feel i am not getting used to this stage. Actually what is range map? and where we should use this range partitioning? Cant we use range parttioning on a data without this range map stage? Is thsi stage used in real ...

try this

TRIM(TRIM(COL_NAME,CHAR(10)),CHAR(13))

trim(col_name,' ','A')
try this

how to compile routines manually through manager,as we have moved routine folder from DEVELOPMENT to QA,routines are in locked position,i didnt find any manual option to compile routines through manager

I am reading a fixed width records from unix box through a sequential file and Reject mode option is set to 'FAIL' in sequentafl file stage. Do the datastage specify the line number of the rejected record if there are any rejections or else we have explicitly put a reject link and handle that.

i have data like 110456789234567 in Column1. Now my output should look line 110 456 789 234 567 all in column 1. First 3 into ist row, next 3 into 2nd row etc... how can i split the data. Is this possible using a row splitter. What delimiter can i give for input data