58942 | 04 Aug 2016 @ 02:59 PDT | dnoeth | Database | Reply | Need help with interdependent calculation using result from previous row | Based on the example data you don't need to use the previous row's data, it's just the minimum start date plus a cumulative sum of supplied days:
min(SELL_DATE)
over (partitio... |
58941 | 04 Aug 2016 @ 02:40 PDT | Ivyuan | Tools | Reply | Record count from worktable in mload | Hi,
Here is Locking summary during a MultiLoad job:
- Begin MLOAD Step
. Target table
- write lock
. Work table
&... |
58940 | 04 Aug 2016 @ 01:40 PDT | fgrimmer | Teradata Studio | Reply | Not working: Default connection for new SQL files | Steven, This option is used for the SQL File Editor and not the Teradata SQL Editor. The SQL File Editor is for non-Teradata connection profiles, such as Oracle, DB2, SQL Server. If you want the ne... |
58939 | 04 Aug 2016 @ 12:21 PDT | Fred | General | Reply | Multi Column Primary Index and Secondary Index | How often will you retrieve a specific (acctid, Bus_date) combination?
How often will you retrieve data for an acctid but not know the specific Bus_date?
|
58938 | 04 Aug 2016 @ 12:16 PDT | dbrown | Database | Reply | Need help with interdependent calculation using result from previous row | kirthi, unfortunately that results in the same problem. The second row is ok, but the third row fails to reference the previous row's adjusted end_date, so the adjusted sell_date occurs before ... |
58937 | 04 Aug 2016 @ 11:47 PDT | kirthi | Database | Reply | Need help with interdependent calculation using result from previous row | Guess this one works
SEL
CUST_ID
,SELL_DATE
,SUPPLY_DAYS
,ROW_NUMBER () OVER ( PARTITION BY CUST_ID ORDER BY SELL_DATE) AS MAIN_ROW_CNT
,CASE WHEN MAIN_ROW_CNT = 1 THEN ... |
58936 | 04 Aug 2016 @ 11:31 PDT | Fred | General | Reply | error table's are invalid state or table is being loaded | Yes, this error comes from Data Connector. When you do DEFINE SCHEMA schemaname FROM TABLE tablename, the schema is generated based on the column names and data types.
If your input data... |
58935 | 04 Aug 2016 @ 10:49 PDT | Private Forum |
58934 | 04 Aug 2016 @ 09:38 PDT | SNguyenWF | Teradata Studio | Topic | Not working: Default connection for new SQL files | Under Preferences > Data Management > SQL Development > SQL Editor > SQL Files/Scrapbooks, there's a setting for "Default connection information for new SQL files/scrapbooks&qu... |
58933 | 04 Aug 2016 @ 09:29 PDT | fgrimmer | Teradata Studio | Reply | DB2 JDBC connections not showing in SQL Editor Connection Profile: dropdown | Lilit, I am assuming you are running the Pentaho Report Designer plugin on Eclipse? What database are you connecting to?
|
58932 | 04 Aug 2016 @ 09:10 PDT | mk104 | Database | Topic | Identify rows that already exist in same dataset and group them by date | Hi all
I am having some trouble with a big dataset. The dataset is comprised of clients, platforms (its ids), code of platform and Period platform created.
I am trying for each period group to ... |
58931 | 04 Aug 2016 @ 08:10 PDT | manishdasin | Viewpoint | Reply | Is there a way to control RESPONDING STATE of large extracts using TASM Exceptions? | No.
If you could mention your goal, we may think of options.
|
58930 | 04 Aug 2016 @ 07:35 PDT | dbrown | Database | Reply | Need help with interdependent calculation using result from previous row | Thank you for your input, Kevin. Your suggestion of using partition by and preceding was what I had come up with and doesn't work, the problem being that it needs to look at the calculated valu... |
58929 | 04 Aug 2016 @ 06:58 PDT | kirthi | Database | Reply | PPI | It helps in Dynamic partition elimination if you use the partition column in the where Clause.
|
58928 | 04 Aug 2016 @ 06:58 PDT | VandeBergB | Data Modeling | Reply | AJI creation for a single high priority query | For starters, you can't build a JI against view columns, you'll need to start with the base table columns. start by recreating this exact query with base table columns, including any ... |
58927 | 04 Aug 2016 @ 06:52 PDT | kishorwithk@gmail.com | General | Reply | interview help | hi,
please forward the questions to kishorwithk@gmail.com
regards,
kishore
|
58926 | 04 Aug 2016 @ 06:38 PDT | jkurdsjuk | Data Modeling | Reply | AJI creation for a single high priority query | I suspect this question might be get a better response in a different sub-forum like DATABASE.
|
58925 | 04 Aug 2016 @ 06:21 PDT | jester666 | Teradata Database on AWS | Topic | pkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0 | After upgrade python from 2.6 to 2.7 on Teradata Database Developer (Single Node) AMI could not execute tdc-init, tdc-start: td-aws-ins-config is missing.
Is there any chance to download it separa... |
58924 | 04 Aug 2016 @ 06:17 PDT | LUCAS | Database | Reply | skew factor | BTW,
i just notice a case where a small table is displayed with a high skew by TD Administartor (15.00):
Space by AMP gives 8 lines with almost the whole of 1.3 M lines on one AMP, although a que... |
58923 | 04 Aug 2016 @ 06:04 PDT | mb255021 | Data Modeling | Topic | AJI creation for a single high priority query | Hi Everyone,
I have the following query for which I have to create an AJI:
select a11.MAT_GRP_GL_ACCT_ID MAT_GRP_GL_ACCT_ID,
a12.FISCAL_PERIOD_NAME FISCAL_PERIOD_NAME,
a1... |
58922 | 04 Aug 2016 @ 06:03 PDT | LUCAS | Database | Reply | skew factor | This is because of the location of all NULLs on a same (and single) AMP, according to the hash process
Pierre
|
58921 | 04 Aug 2016 @ 05:15 PDT | Arslannadeem | Database | Topic | Cannot view internal dbs control settings through viewpoint -teradata 1650 - Error Illegal option | Hi,
I am trying to view DBS internal settings through remote console on teradata 1650(Extreme Data Appliance) .
It gives an error "Illegal option".
Can any... |
58920 | 04 Aug 2016 @ 04:36 PDT | lokesh_meesala | General | Reply | error table's are invalid state or table is being loaded | Hi Fred,
thanks much sfor response.
i would be seeing the below error if file column value is exceeding the taget column length.
op_EMP_NAME[1]: TPT19134 !ERROR! Fatal data error process... |
58919 | 04 Aug 2016 @ 03:56 PDT | Lilit_M | Teradata Studio | Reply | DB2 JDBC connections not showing in SQL Editor Connection Profile: dropdown | in Pentaho Report Designer jdbc data source query editing button not functional. what's happend?
|
58918 | 04 Aug 2016 @ 03:13 PDT | sargofco72 | Connectivity | Reply | Unable to Connect to Teradata Database from Teradata Studio on iOS (Mac) | Hello Fred, thank for your help. If I ping this name (this is the name that I set in the hosts file associating with a IP of the Teradata Server) and ping directly the IP, I don't have response... |