DSXchange

Hi I was getting this warning when i did that Agg: When checking operator: User inserted sort "Agg.ToAgg_Sort" does not fulfill the sort requirements of the downstream operator "APT_SortedGroup2Operator in Agg" But when i unchecked the Perform Sort in the Aggregator it worked Tha...

Hi I am using a Aggregator stage in a PX job , Doing hash partitioning on it and sorting the data as well I am getting these warnings Agg,1: Hash table has grown to 16384 entries. Agg,0: Hash table has grown to 16384 entries. ..... Can anyone please suggest how to get rid of these warnings Thanks

HI
When doing a look up i am using entire partitioning , The warning message which i am getting is
APT_ParallelSortMergeOperator(10),0: Unbalanced input from partition 0: 10000 records buffered

Please advice over this

Thanks

record ( Part_ID: string[max=255]; Cust_ID: string[max=50]; Cust_ASM: string[max=50]; Cust_GSM: string[max=50]; UNIT: sfloat; REVENUE: sfloat; UNIT_EXP: sfloat; CREATE_DATE: timestamp; CURRENT_FLAG: string[max=1]; T_Date: timestamp; ) The source column Quantity is getting divided into 3 columns Unit...

Hi Ray
Its not just the view data , but i am loading the data in the dataset into the target table , the target data for that clolumn in being rounded to 3 decimal places

Thanks

Yes i have tried all the possible data types with precision , without precision

Hi In my source table i have a column "quantity" which has data type "real" having length as 7 . say for example one value is 12.76378682376 , when i load it directly into the database table its getting loaded fine . but i have to follow a few steps before so i am loading it into...