Comments
-
I'm in version 5.0 and would like to know how do we enable UPSERT functionality in workbench, do we have to place an additional request? Also, I would like to check to see if the upsert functionality development completed? if so could you please guide us the steps to use the UPSERT feature as we are loading huge amount of…
-
Thanks Matt for providing the steps to solve data load issue. 1. I was able to load the data in small chunks (row count <= 5 million rows), I have applied replacement variable for one of unique columns and was able to load the data by scheduling the job to run every 15 mins. 2. Per your suggestion, I have increase the job…
-
Thanks for the response and apologies for the delayed response. I tried to apply the logic you have mentioned (select * from table where cluster between '{lastvalue:cluster}!' and '!{lastvalue:cluster}!'+2000000 order by cluster) to do initial data load to the dataset and i see "Replacement parameter does not contain a…
-
Thanks for the response. For the reports/ID...do you mean that you want 1 report / 1 customer ID? or a group of customer IDs get one format and another group gets another? >> For example, I have 500 unique row's and 10 columns in a table and out of which one column is customer ID, so I have to create one template/report…
