DSXchange

check the ulimit size for the user who runs this job..also when u r handling that much data..it is advised to use a join instead of look up..look up doesnt give u performance..take it for granted

Hi there

IsNull function will not work for a int data type.So look there

can you juss check if u r using a basic transformer in a parallel job???

Eric wrote:As the job seems to start running and then fail, perhaps there is an item of data in the source table that is causing the problem?

u can use the orchadmin utility to manage those datasets. the command takes options dump,delete,copy etc..so u do what ever u want to do.. Did you ever get an answer to your questions? I am looking at the Scratch and Datasets directories and wondering if it is possible to clean them up. I do not wan...

performance wise merge and join are almost the same..if you want the rejections as well u have to with merge..or else..both behave in the same way.. I have tree tables (~10M row/table, 1k/row), Is it better performance to use a merge stage in DS and send output to a DataSet or do a DB2 table join an...

can you post the error message?? I have 2 fields which I am passing to the lookup stage as a reference from the Oracle Database. One of the fields of the two which is a key field is generated by the system. I am getting a NULL VALUE FOUND error on that field, which is very unfair. Its a sequence num...

Hi there.. this is a problem with the StringToDecimal function..we did a work around by converting the value to a int and then multiplying it with 0.01. dont know the cause,but its a problem with the function.. Hi, In one of my jobs I am using StringToDecimal function. Input to this is a varchar col...