All forum activity

#DateUserForumTypeThreadPost
5834212 Jul 2016 @ 12:27 PDTM.Saeed KhurramDatabaseReplyStoring History DAta into tablesHi, The table is already partitioned so performance should not be an issue. Can you please paste the DDL so that the table structure can be understood? Also, Have you considered the stats collec...
5834112 Jul 2016 @ 12:24 PDTM.Saeed KhurramDatabaseReplyTD 14 - Data Storage QuestionsHi sallad, If you are new to Teradata, I would suggest to read Teradata SQL Bascis guide. It will help you to answer all these and many more questions.
5834012 Jul 2016 @ 12:20 PDTM.Saeed KhurramDatabaseReplyFaster way to delete and rebuild a tableHi, Even if you skip all the steps and do only step 7, the result will be same.
5833911 Jul 2016 @ 11:47 PDTdrmkd17DatabaseTopicStoring History DAta into tablesI have a requirement to fit in 441GB of history data into a table which makes my table bulky and difficult to query. Just to explain it is a fact table and stores amount fields etc. I have a partit...
5833811 Jul 2016 @ 05:42 PDTsalladDatabaseReplyTD 14 - Data Storage QuestionsThanks a lot for the quick and detailed response, this makes sense now!
5833711 Jul 2016 @ 03:56 PDTFredDatabaseReplyFaster way to delete and rebuild a tableSo both step 2 and step 5 insert ALL the data (no WHERE clause)? And table A is dropped before applying the new data to B? (which would mean it's not really a "safety copy") Why...
5833611 Jul 2016 @ 03:30 PDTN_RaghuToolsTopicTeradata SQL Assistnat 15.10.1.4: Tab colorsI am using Sql assistant 15.10.1.4. Tab color is not changing to pink while executing a query Also does not change to green after query completion as we use to have in previous versions. I did chec...
5833511 Jul 2016 @ 03:22 PDTrompstarDatabaseTopicsaving a python DataFrame to Table hi guys // so I am learning python, because that is a tool more and more requested these days at companies of all size (small and large). So, I am able to Connect into the database fine using PYOD...
5833411 Jul 2016 @ 11:12 PDTthnkgreenDatabaseTopicFaster way to delete and rebuild a tableHello everyone.  This is my first post.  I have a question about deleting and rebuilding tables.  I have inherited some code that is structured like 1.  create an empty table i...
5833311 Jul 2016 @ 11:00 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI removed the -data parameter from program launch (thus, using the default workspace location) and still having the same lag issue.  I might just have to resort to using SQL Assistant if the i...
5833211 Jul 2016 @ 10:39 PDTabhishek.jadhavDatabaseReplyRestore using DSA with NO BUILD option.Tables which are being restored using DSA cannot be built by BUILD command using ARCMAIN. DSA restore job will automatically perform the build as one of the job phases.
5833111 Jul 2016 @ 09:19 PDTFredDatabaseReplyTD 14 - Data Storage Questions1) See answer # 3 2) That's the preferred option - if the data is supposed to be a character string, use a string constant (even if the characters happen to be digits). 3) If you SELECT 12345...
5833011 Jul 2016 @ 08:11 PDTtomnolanDatabaseReplySQL error using Teradata JDBCYou said that you are trying to find the reason for the behavior difference.   As I mentioned already, the behavior difference is likely due to you using different transaction modes in the s...
5832911 Jul 2016 @ 05:25 PDTToddAWalterDatabaseReplyDifference between event code and crash code3610 is a generic code that says something happened that the Parsing Engine couldn't deal with. The crash code is additional information that tells what area of the Parssing Engine had the issu...
5832811 Jul 2016 @ 02:01 PDTsharonnConnectivityReplyPing Failed - can not connect to Teradata on Linux - awsThank you Dieter, I’ve decided creating a new TDE machine. Since there is no longer TDE in AWS, I would like to create a linux machine in AWS and install the TDE VM on it. Do you have any...
5832711 Jul 2016 @ 12:34 PDTJohannes VinkViewpointReplyViewpoint SUSE CompatibilityVP 15.10 is compatible with SLES10. VP15.11 is only SLES11. Why not upgrade to SLES11/VP15.11?
5832611 Jul 2016 @ 12:29 PDTM.Saeed KhurramAsterReplyAutomating grants in AsterHi, You can use executables option in AMC, build your script and schedule it as per your requirement. Br, Khurram
5832511 Jul 2016 @ 12:23 PDTM.Saeed KhurramAsterReplyLoading JSON to ASTERHi, Have you tried AFS connecter?  
5832410 Jul 2016 @ 11:32 PDTjohnsunnydewDatabaseTopicFind the minimum alignment date query based on alignment numberHi Frinds, Need your help. I need to find the minimum alignment date of alignment numbers. Alignment No Alignment_Date 30 20...
5832310 Jul 2016 @ 11:29 PDTWAQDatabaseReplyCalculate column value based on previous computed valueHere are DDL's and DML's for the above example: drop table test; create volatile table test ( org varchar(5) ,dest varchar(5) ,FRU integer , VEG integer ) on commit preserve...
5832210 Jul 2016 @ 11:28 PDTWAQDatabaseTopicCalculate column value based on previous computed valueHi, I have a requirement to make a derived column called TOTAL which is calculated by subtracting FRU from VEG column (based on grouping of org and dest) and then for every next row calculate the...
5832110 Jul 2016 @ 11:13 PDTarchana_2016ToolsReplyTPT02639 - Conflicting data type error for columnHi Steve Version used is 14.00.00.09. By using cast conversion we were able to solve the issue but the chinese characters are not getting exported appropriately. Is there anything to do with the e...
5832010 Jul 2016 @ 09:27 PDTsalladDatabaseTopicTD 14 - Data Storage Questions --create table CREATE SET TABLE database.table,  NO FALLBACK ,  NO BEFORE JOURNAL,  NO AFTER JOURNAL,  CHECKSUM = DEFAULT,  DEFAULT MERGEBLOCKRATIO  (  ...
5831910 Jul 2016 @ 01:20 PDTPrateeDatabaseTopicDifference between event code and crash codeFor one snapshot , I received event code as 3610 and crash code as 3650. Most of the time it happenes event code is different than crash code. Can anyone tell what is actual different between eve...
5831808 Jul 2016 @ 02:41 PDTdnoethDatabaseReplyoTranslate issueYour query will remove the characters not in the list, only the first character (a space) will be replaced by a space.  As oTranslate replaces each character in the 2nd parameter with the cha...

Pages