DSXchange

Well..

you have to verify the contents of the particular field before perform the actual conversion.

you should do something like below Edi

we had this earlier and we set the input links partition type = Hash & sort
&
In DB2 API stage,set preserve partitioning=clear.

Edi

This warning is due to the same column name on Join/lookup.
Check the field names on the links to the JOin/Lookup and renaming the names will get rid of the warning.

Regards,Edi

there are couple of things you need to care... just verify all the decimal field null handling properties( DO Null to zero....etc..wherever necessary/applicable) if there is something wrong with any of the decimal field which may be in some column derivation is wrong then that might be the reason..(...

ravibabu wrote:hi,

can you tell me ,You are useing SMP or MPP systems.

I think problem with resource sharing better to use MPP system.
lack of resource problem.

Sorry & Please don't post Offtopic's which will mislead the discussion!

Thanks,Edi

My dear friend ,pls split the job as small as possible.this method is very useful for error fixing in the future... Thanks my friend! this design already has 40 + joins - 100 + stages involved so while designing i have splited as 3 piece's already..which i should join in future( our aim is to reduc...

DSguru2B wrote:Ok. Whatever you business approves. Thought I'd point that out to you.

Thanks DSB! i'll colse this as resolved.

Edi.

If the inputcolumn is Zero's then it's writing as +0000000.00 which is fine. You sure thats ok. Zero is neither negative nor positive . Double check with your business if thats acceptable. OK..will do... But if the if a particular column of the row is zero and if we are not writing anything, that w...

Also as suggested earlier, do the DecimalToString() in a stage variable so that it gets executed once per row, instead of three times as per your code. As of now, I am not doing the DecimalToString() on stage variable because there i am handling Null's On stage variable "svipc" If IsNull(...

Thanks DSG, it's working good after the correction suggested. :D If Index(DecimalToString(inputcolumn,"fix_zero"), "-", 1) > 0 then DecimalToString(inputcolumn) else "+":TRIM(DecimalToString(inputcolumn)) I am handling null's separately(Null to Zero) on the stage variab...

Thanks everyone for coming in! Ganesh,thanks for the Idea, i will try this later.. Ds, I tried yours Idea. But output all zero's If INDEX(DecimalToString(DSLink213.ADJ_NET_FNDG_AMT), "-", 1) > 0 then DecimalToString(DSLink213.ADJ_NET_FNDG_AMT) else "+":TRIM(DecimalToString(DSLink...

All, When we are extracting numeric fields (decimals) into a sequential file, we do not observe a plus sign when decimals have a precision (let's say 14,2 decimal). We want to end up with +XXXXXXXXXXXX.XX But we are getting _XXXXXXXXXXXX.XX where _ is a space. Is there a way to accomplish this with ...

And who lay that limit and why? If you have something, use it. Dont tell me your not using it because its slow. What version of DS are you on? Version 7.5.2 I thought of disputing this with the design lead's here. can I see some docs like Buildop vs. transformer performance compare or transformer i...

kumar,ds,

I do have transformer & modify...

transformer I should not use..

and modify...because i have large number of columns and Modify breaking the metadata mapping & i need to rename most of the columns.so for each and every column,i need to write a specification in modify.

thanks,edi

What is your current job design (What is your source)? Why can't you use Transformer? ... I am reading data from a dataset Renaming the columns Writing on to the fixed width sequential file (no delimiter) Transformer!! ?? I dono how i am going to write buidop code for all transformation rules...thi...