All forum activity

#DateUserForumTypeThreadPost
5861721 Jul 2016 @ 01:13 PDTzakywAnalyticsTopicQUERY IN ASTER Hi Guys  I'm Zaky  In here , i've a problem with query in aster , because this the first moment for me ,  so , my question is , can you give me references or tell me how t...
5861621 Jul 2016 @ 01:04 PDTgtmmajTeradata StudioReplyTeradata 15.1 Error when trying to execute queryI am getting the following error message: Failed to execute SQL: org.eclipse.datatools.sqltools.db.service.GenericSQLService cannot be cast to com.teradata.datatools.dtp.sqltools.db.teradata.s...
5861521 Jul 2016 @ 01:03 PDTgtmmajTeradata StudioReplyTeradata 15.1 Error when trying to execute queryIsroxas, how did you fix this issue? Could you please share.  
5861421 Jul 2016 @ 12:29 PDTKNToolsReplyDetermine #sessions to set for load / exp jobsThank you... Todd and Steve.. In our Tasm the no of session set for for default,large and small fexp jobs have been set to 4 ,4 & 2 respectively.. TASM will not auto calculate the no of ...
5861321 Jul 2016 @ 12:28 PDTdrmkd17DatabaseReplyUsing WITH Statement Modifier instead of Temp Tables?How better is the CTE approach than a derived table .??Any recommendations when to use a CTE instead of a derived table. 
5861221 Jul 2016 @ 12:13 PDTzakywAsterReplyAster 6.0 to HDP 2.1 select does not workHai All  i will introduce myself ,  my name is zaky wibowo   in here , i have a question about query in aster , currently i have some problem about query in aster  cause , i...
5861120 Jul 2016 @ 11:56 PDTdnoethAnalyticsReplyHow to create churn data for customers by transaction in month?Answered on StackOverflow: How to by pass case not when exists in teradata? Btw, recursive is not bad in Teradata if it's done the right way :)
5861020 Jul 2016 @ 10:06 PDTpmooshTeradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Have the same issue and I think @tisenhart is right. It's fs check that takes so long, I didn't have the issue before. I would like to deploy an instance via an automation tool, so this is ...
5860920 Jul 2016 @ 07:28 PDTAMIT@TDDatabaseReplyData Dictionarythanks Dieter for your help. :) 
5860820 Jul 2016 @ 07:06 PDTtisenhartTeradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Thank you for the replies, i tried them all and was still having an issue.  However, after leaving the instance up for about an hour while trying to debug and write this reply, finally my ssh ...
5860720 Jul 2016 @ 06:43 PDTmc200018Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)To connect the instance, please check follows from AWS instance console. 1. The Instance State should "running" state 2. The Status Checks shoule "2/2 checks passed" state &n...
5860620 Jul 2016 @ 06:06 PDTmintsToolsReplyTPT Export vs Fast Exportdoes TPT support case below 100,000 records from one single table,  and when doing export, automatically split 100,000 records into mutiple files, say into 10 files, each file contains 10000 ...
5860520 Jul 2016 @ 03:35 PDTac110057Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Also double check that you opened port 22 to your IP address or your compainies IP address. When it is a company IP address it is usually autodetected in the drop down menu. It is usually not the e...
5860420 Jul 2016 @ 02:38 PDTau185006Teradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)When you state that "The AWS instance state shows the instance is unreachable" this sounds like a problem with the deploy from AWS side.    I would drop the instance and re...
5860320 Jul 2016 @ 01:39 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTIf you write a script and put the SELECT statement in the script, the single quotes will not be stripped.
5860220 Jul 2016 @ 01:26 PDTbassheadAnalyticsTopicHow to create churn data for customers by transaction in month?So I have created a table that has the following columns from a transaction table with all customer purchase records: 1. Month-Year, 2.Customer ID, 3. Number of Transactions in that month. I&#...
5860120 Jul 2016 @ 08:27 PDTk_jalevViewpointTopicLimit a role to only one Teradata system of several activeHi,   We have several systems managed through single installation of Viewpoint, version is V14.10.00.08-b61   We are trying to create a User role and to give it full administrative ac...
5860020 Jul 2016 @ 08:06 PDTVandeBergBToolsReplyFOR EACH clause in Teratada SQLare you looking for the first day of each month for the year ?   if so , join to the sys_calendar.calendar view on the date, with the additional condition of where day_of_month = 1
5859920 Jul 2016 @ 07:25 PDTrmrossiToolsTopicFOR EACH clause in Teratada SQLI have the statment below: INSERT INTO P_WENL.RR_tmpParque2 SELECT          Prqe.dt_foto_lnha         ,Pssa.cdCliente     ...
5859820 Jul 2016 @ 03:43 PDTdnoethDatabaseReplyData DictionaryThe size of the actual Data Dictionary tables (excluding TransientJournal, AccessLog, QueryLog, ResUsage) is way less than 1% of the system's perm space. Best practices recommend to reduce the...
5859720 Jul 2016 @ 03:13 PDTAMIT@TDDatabaseReplyData DictionaryThanks dnoeth. please eleborate Q2. and if space is more then why do we bother to save data dictionary space.??
5859620 Jul 2016 @ 02:13 PDTAbhijeet.ShahTeradata Database on AWSReplyAWS instance unreachable for Teradata Database Developer (Single Node)Please use Public IP address or Public DNS of instance for ssh connection. Note that "ec2-user" is the user you need to use for ssh connection as shown below, :~# ssh -i private-key-fil...
5859520 Jul 2016 @ 02:03 PDTM.Saeed KhurramAsterReplyAster 6.0 to HDP 2.1 select does not workHi, It seems to be a problem from Cloudera. have you made any upgrade to Cloudera server? Are you able to ping the server 'smp200-8_eth4' from Aster machine?  
5859420 Jul 2016 @ 01:42 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTAny way to make sure single-quotes present in the SELECT statement that is sent to Teradata and overcome this issue?   Thanks, Hanu
5859320 Jul 2016 @ 01:39 PDTM.Saeed KhurramDatabaseReplyFastload Duplicate Records issuesAs you told earliar the fastload script got aborted. Fastoad only load into an empty table.  Can you check if there is no data in the Target table? Otherwise the best option is to use NOPI t...

Pages