DSXchange

to provide additional info All these have been set to unlimited except two initially: time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 32768 memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) 2048 but Stack is being set to unlimited in dsenv u...

My job aborts first throwing the below warning message The current soft limit on the data segment (heap) size (1610612736) is less than the hard limit (2147483647), consider increasing the heap size limit and then the below fatal error message: Fatal Error: Throwing exception: APT_BadAlloc: Heap all...

yes i understand the sort is superfluous... initially i had tried without any sorting..it was not working.then i tried an internal sort... i.e if you open the input for lookup u will have an perform sort option..that is internal sort.

by external sort i meant i am using a seperate sort stage.

not exactly..... only if i am sorting within the input of the lookup stage(intra stage sort) and then partition it works fine.If i use an external sort and then partition again the same thing happens...it fails.

yes have checked it..data is exactly same on both sides and one thing which is noteworthy is when i am doing an internal sorting and then hash partitioning in the inputs to the lookup stage for both the links the look up is working perfectly fine since i will be processing huge amount of data i cann...

Hi All, Tried trimming on both sides for both the columns.... still didnt work....length is same for both !!!! Any idea what wud have possibly gone wrong?

ok i understand what u guys are trying to say.so for both the links i.e. main and ref i would trim the data.possibly while fetching the data coming from ref link i.e. teradata enterprise stage i will select it with a trim(src_ref) and for the main link i would have to use a transformer to trim the a...

i will explain in detail what exactly i have done so that it helps u guys analyze the situation.I am partitioning on a single column.The main link data is fed from a data set column name- asset_val(varchar(100)) while the ref link data,column name- src_ref(varchar(100), on which i am looking upon ,i...

i have a lookup stage where in i am hash partitioning the main and reference link data on a certain key in the input of the lookup stage.to my surprise look up failed since the values inspite being same on main and reference links were in different partitions.introducing a peek stage after modifying...

i have a lookup stage where in i am hash partitioning the main and reference link data on a certain key in the input of the lookup stage.to my surprise look up failed since the values inspite being same on main and reference links were in different partitions.introducing a peek stage after modifying...

My job gets aborted with teh following error message

Contents of phantom output file =>
RT_SC597/OshExecuter.sh: line 20: 6654 Segmentation fault (core dumped) $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1

Can anyone help me on this?

but it works in windows!!!! I need an unix equivalent

Hi All, Can anyone help me in exporting a number of dsx's from a particular project and server using a unix command.Is there any unix command which when triggered will export a dsx from a particular Datastage project and serevr. There is one whcih works in winfows but the same doesn't work with Unix...