# | Date | Forum | Type | Thread | Post |
8 | 26 Sep 2013 @ 08:40 PDT | Tools | Reply | Teradata Parallel Transporter Wizard 13.10 Issues | I 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... |
7 | 26 Sep 2013 @ 05:53 PDT | Tools | Reply | Teradata Parallel Transporter Wizard 13.10 Issues | Does anyone know what folders and permissions need to be corrected before the wizard can run successfully?
|
6 | 24 Sep 2013 @ 11:14 PDT | Database | Reply | Creating Group ID from SUM Limit | I 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... |
5 | 09 Sep 2013 @ 02:02 PDT | Database | Reply | Creating Group ID from SUM Limit | Is 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... |
4 | 05 Sep 2013 @ 09:29 PDT | Database | Reply | Creating Group ID from SUM Limit | I 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... |
3 | 05 Sep 2013 @ 08:40 PDT | Database | Reply | Creating Group ID from SUM Limit | I 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 ... |
2 | 04 Sep 2013 @ 01:46 PDT | Database | Reply | Creating Group ID from SUM Limit | I 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.
|
1 | 04 Sep 2013 @ 01:40 PDT | Database | Topic | Creating Group ID from SUM Limit | I 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  ... |
|
|