DSXchange

Im using 6 datasets using Left Join stage. 3rd dataset is not joining properly. Join works fine if i use the Hash partitioning on 3rd dataset and mainstream data. But then should i have to revert back hash partitioning to Automatic so that output can join properly to other remaining datasets. Please...

It works fine..Thanks Ray.

I want to a compare of date (yyyy-mm-dd) with system date -15 years in Transformer in px. What functions should i use.

If source is spread sheet then just use the SEQUENTIAL FILE stage and link to database stage. do your transformation in any appropriate stage or use transformer in between.

DFloatToDecimal(Link.DblCol, "round_inf") works fine in transformer when making stage variable to Decimal with 2 decimal places. Would it be able to handle a value for Double (53). What should be the decimal data type equivalent to Double (53) ?

ArndW:
I couldn't understand it. what is the syntax of round_inf ? please explain.

ArndW:
INT(In.DBLCol*100)/100 function is not available in px. and i tried to put decimal with 2 decimal places, it doesnt round.

I want to do this in Transformer in Px and source is Double (53) and Target is Double (53) in dataset which is then populated in db2 - Double (53).

i want to Round to 2 decimal places input and output is same i.e double (53)

I already solved it by adding another tx before where i was initializing with zeros and its working.

Thanks for help.

I already solved it by adding another tx before where i was initializing with zeros and its working.

Thanks for help.

if i use stage variables ?

<main_program> Error when checking composite operator: Output from subprocess: D:\DDPSM07\Data\DS\Dev\Projects\PPAM_DEV\RT_BP466.O\V34S0_jp9MergingPpamData_a_xfmChar0toSpac.C(319) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data

Im Initializing some columns with 0 and there datatype is DOUBLE in a transformer. It gives me compilation error. My table has 400 colums. It is working fine if i assign column derivation to these colums. Following is the error: I dont know what im doing wrong: <transform> Error when checking compos...

Although i have been using the following shorcut keys while my Text menu was disappeared. When i started using these keys it suddenly appeared separately at the bottom corner and i placed it back..

FILE: Alt F
Edit: Alt E
View: Alt V
Tools: Alt T
Window: Alt W

Thanks for your help.