DSXchange

nothing is happening simple one to one mapping

oracle stage ---->Transformer------>Seqfile

in oracle stage i used user defined query.that is giving the data at source when ever i view through the view tab.

yes ray i was reset the job this is the log can you help me From previous run DataStage Job 2311 Phantom 9340 Program "JOB.1396960201.DT.1465440079.TRANS1": Line 107, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage testsummary..Transf...

andrew can you help in details because only warning message is there in log

Can any one help me i got this warning what is cause for this
warning message:Attempting to Cleanup after ABORT raised in stage testsummary..Transformer_1
i am trying to load the data from oracle stage to seq file.

i got thanks alot

thanks alot,still i heve one more query that i have a transaction data withoutspaces i need to make lookup with master data which might be exist with spaces so that is the case look up will fail how can i prevent this situaation actually this is my requirement .

yes varchar data only.if i use trim also it is not giving now

Hi can any one help me how to remove space in a string. i know trim function.but it is not working.remove function is there but how to use it?delimeter is space but it is not taking.
ex;string is like bang lore
i want banglore:i used like this remove(string,' ') it is not working

no i know this but i want opposite to your answer.like please change your data i mean emp.txt file should be dept table and table should be emp.txt data.if one record match with multiple records in table that record shpuld reject.

Hi Can any one help me that how to convert server jobs into PX jobs

hi sachin thanks for response but i want to make a look up with table.

Using data satge i want to reject that data if multiple matc occure

which option u taken in after subroutine tab makesure that option should ExecSH

i know that is not called masterdata but i want know if one match with multiple records in with particular table how can i found wether particular record match with multiple record in table.assume that my source is CSV file but i want to validate with table.there is a possiblity that duplicates in m...