All forum activity

#DateUserForumTypeThreadPost
5894404 Aug 2016 @ 02:59 PDTdnoethDatabaseReplyNeed help with interdependent calculation using result from previous rowBased 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...
5894304 Aug 2016 @ 02:40 PDTIvyuanToolsReplyRecord count from worktable in mloadHi, Here is Locking summary during a MultiLoad job:  - Begin MLOAD Step    . Target table       - write lock    . Work table &...
5894204 Aug 2016 @ 01:40 PDTfgrimmerTeradata StudioReplyNot working: Default connection for new SQL filesSteven, 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...
5894104 Aug 2016 @ 12:21 PDTFredGeneralReplyMulti Column Primary Index and Secondary IndexHow 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?  
5894004 Aug 2016 @ 12:16 PDTdbrownDatabaseReplyNeed help with interdependent calculation using result from previous rowkirthi, 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 ...
5893904 Aug 2016 @ 11:47 PDTkirthiDatabaseReplyNeed help with interdependent calculation using result from previous rowGuess 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 ...
5893804 Aug 2016 @ 11:31 PDTFredGeneralReplyerror table's are invalid state or table is being loadedYes, 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...
5893704 Aug 2016 @ 10:49 PDTPrivate Forum
5893604 Aug 2016 @ 09:38 PDTSNguyenWFTeradata StudioTopicNot working: Default connection for new SQL filesUnder Preferences > Data Management > SQL Development > SQL Editor > SQL Files/Scrapbooks, there's a setting for "Default connection information for new SQL files/scrapbooks&qu...
5893504 Aug 2016 @ 09:29 PDTfgrimmerTeradata StudioReplyDB2 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? 
5893404 Aug 2016 @ 09:10 PDTmk104DatabaseTopicIdentify rows that already exist in same dataset and group them by dateHi 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 ...
5893304 Aug 2016 @ 08:10 PDTmanishdasinViewpointReplyIs 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.
5893204 Aug 2016 @ 07:35 PDTdbrownDatabaseReplyNeed help with interdependent calculation using result from previous rowThank 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...
5893104 Aug 2016 @ 06:58 PDTkirthiDatabaseReplyPPIIt helps in Dynamic partition elimination if you use the partition column in the where Clause.
5893004 Aug 2016 @ 06:58 PDTVandeBergBData ModelingReplyAJI creation for a single high priority queryFor 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 ...
5892904 Aug 2016 @ 06:52 PDTkishorwithk@gmail.comGeneralReplyinterview helphi, please forward the questions to kishorwithk@gmail.com   regards, kishore
5892804 Aug 2016 @ 06:38 PDTjkurdsjukData ModelingReplyAJI creation for a single high priority queryI suspect this question might be get a better response in a different sub-forum like DATABASE.
5892704 Aug 2016 @ 06:21 PDTjester666Teradata Database on AWSTopicpkg_resources.DistributionNotFound: td-aws-ins-config==1.0.0After 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...
5892604 Aug 2016 @ 06:17 PDTLUCASDatabaseReplyskew factorBTW, 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...
5892504 Aug 2016 @ 06:04 PDTmb255021Data ModelingTopicAJI creation for a single high priority queryHi 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...
5892404 Aug 2016 @ 06:03 PDTLUCASDatabaseReplyskew factorThis is because of the location of all NULLs on a same (and single) AMP, according to the hash process Pierre
5892304 Aug 2016 @ 05:15 PDTArslannadeemDatabaseTopicCannot view internal dbs control settings through viewpoint -teradata 1650 - Error Illegal optionHi,   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...
5892204 Aug 2016 @ 04:36 PDTlokesh_meesalaGeneralReplyerror table's are invalid state or table is being loadedHi 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...
5892104 Aug 2016 @ 03:56 PDTLilit_MTeradata StudioReplyDB2 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?
5892004 Aug 2016 @ 03:13 PDTsargofco72ConnectivityReplyUnable 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...

Pages