#DateForumTypeThreadPost
826 Sep 2013 @ 08:40 PDTToolsReplyTeradata Parallel Transporter Wizard 13.10 IssuesI figured it out by giving full control to EVERYONE to the "C:\Program Files (x86)\Teradata\Client\14.10\Teradata Parallel Transporter" folder. Once i granted full control everything work...
726 Sep 2013 @ 05:53 PDTToolsReplyTeradata Parallel Transporter Wizard 13.10 IssuesDoes anyone know what folders and permissions need to be corrected before the wizard can run successfully?
624 Sep 2013 @ 11:14 PDTDatabaseReplyCreating Group ID from SUM LimitI ended up using a suggestion from the guys over at stack overflow. First create a table that has the group id and the upper and lower limits of each bucket. -- create the first entry for the r...
509 Sep 2013 @ 02:02 PDTDatabaseReplyCreating Group ID from SUM LimitIs this the query you mean? I did the whole thing over so that I wouldnt have to do an insert and then an update. This still gives me some weird results what am I missing? WITH PROD_CTE (PR...
405 Sep 2013 @ 09:29 PDTDatabaseReplyCreating Group ID from SUM LimitI tried to construct the query you recommended but when i ran it with over a hundred products it created almost as many buckets and didnt stick to the number of buckets i had wanted. I created anot...
305 Sep 2013 @ 08:40 PDTDatabaseReplyCreating Group ID from SUM LimitI was thinking I may be able to get away with simply distributing the records evenly based on an average or other distribution key. If I had data such as below I would want to distribute them into ...
204 Sep 2013 @ 01:46 PDTDatabaseReplyCreating Group ID from SUM LimitI meant to say, I want to create a group ID where groups are created if the ROLLING sum of the quantity sold is greater than 50.  
104 Sep 2013 @ 01:40 PDTDatabaseTopicCreating Group ID from SUM LimitI have a list of products and a count corresponding to the quantity sold in a single table. The data is laid out as such: Product Name     QTY_SOLD Mouse  ...