All forum activity

#DateUserForumTypeThreadPost
5839213 Jul 2016 @ 04:26 PDTcrispo3DatabaseTopicAdvice on ELT process pleaseHi, We're transitioning from Oracle to Teradata, and we need to replicate our existing ELT process and i'm after some advice/opinions about available options.  We have a file -> s...
5839113 Jul 2016 @ 03:41 PDTdrmkd17DatabaseReplyALTER_PPICan I add a new range partition on a new column in an already created and populated table. 
5839013 Jul 2016 @ 03:26 PDTdrmkd17DatabaseReplyextending MLPPI tablesHi ,    I have a table which is partitioned on BUS_DT with a Range_N partition with data (200 million) . I want to include another  RANGE_N partition on CO_ID . Can I do it throug...
5838913 Jul 2016 @ 01:54 PDTsachin.sebastianDatabaseReplyCalculate column value based on previous computed valueHere you go SEL ORG, DEST ,COALESCE (FRU-SUM(VEG) OVER (ORDER BY VEG DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING), FRU) AS FRU ,VEG ,FRU - SUM(VEG) OVER (ORDER BY VEG DESC ROWS UNB...
5838813 Jul 2016 @ 01:08 PDTsharonnConnectivityTopicCan not connect from host to TDE 14 40G - IP address is not set.Hi, I was using the TDE 14 - 4G successfully but could not load my data due to free space. Now I’m trying to work with TDE 14 – 40G but I can’t connect to the VM from my ho...
5838713 Jul 2016 @ 12:24 PDTWAQDatabaseReplyCalculate column value based on previous computed valueHi Sachin, Thanks for you response. Can we do the same without using CSUM as it is a deprecated function. Also in the output report, I want to display the previous row TOTAL value in the FRU colu...
5838613 Jul 2016 @ 12:18 PDTabhilash.dwbi@gmail.comTeradata StudioReplyNeed help on export file option in tereadata studio expressHi Fgrimmer, just now i tried that option and its working fine for CSV extenssions and am unable to export the file in excel format, after selecting excel format "finish" button going do ...
5838512 Jul 2016 @ 11:02 PDTdrmkd17ViewpointReplyMeaning of basic terms I see in ViewpointThanks:)
5838412 Jul 2016 @ 06:41 PDTsalladGeneralTopicTeradata Forum Account Temporarily BlockedI am logged into my work computer (this is how I am posting right now) but when I logged into a virtual machine I got the password wrong and now I see that my account has been temporarily bloc...
5838312 Jul 2016 @ 06:33 PDTcvsanthoshDatabaseTopicAudit on TeradataHi, Need to capture users who access sensitive information in teradata database. Able to get all the required information from dbc.accesslog such as userid, date and time of login, databasename, t...
5838212 Jul 2016 @ 03:43 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenCREATE SET TABLE SMS_Data_pi.dim_test_result ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM = DEFAULT,    &nb...
5838112 Jul 2016 @ 03:06 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, OK, so you are doing a Copy from one Teradata system to another. Does the destination table exist? If it does, then you want to make sure that you map the columns from source to compatible...
5838012 Jul 2016 @ 03:00 PDTIvyuanToolsReplyFastload - Error on piom GET ROW: 64Hi, 1. Can you let us know the Teradata Data Connector version? This could be obtained by issuing a ".show version;" command using FastLoad. The version will be followed "Teradata ...
5837912 Jul 2016 @ 01:36 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenOn another machine, MacBook Pro, I installed TD Studio 15.11.  Same result.
5837812 Jul 2016 @ 01:35 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenThis is Teradata to Teradata.
5837712 Jul 2016 @ 01:25 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, If you are doing a Data> Load on the table then you want to make sure you have chosen the correct EOL and delimeters.
5837612 Jul 2016 @ 01:22 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, Are you doing a Copy or Fast Load from a file?
5837512 Jul 2016 @ 01:21 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenAlso, FYI, I recently installed the latest version of TD TTU and Studio on a Windows 10 machine. I thought I'd try a different environment so see if it would work.  TD Studio 15.11 on the ...
5837412 Jul 2016 @ 01:17 PDTgarrett@data-design.comTeradata StudioReplyTD Studio data transfer unexpected tokenI've tried this multiple times: where the source file doesn't exist and is created and where the source file exists.  The number of columns is correct.
5837312 Jul 2016 @ 01:14 PDTfgrimmerTeradata StudioReplyTD Studio data transfer unexpected tokenGarrett, This issue may be that the source table has more columns than the destination or visa versa. Can you confirm that the tables have the same number of columns or you have mapped to appropria...
5837212 Jul 2016 @ 12:47 PDTvenkat3107ViewpointReplyMeaning of basic terms I see in Viewpointhttp://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TVPOINT15.11&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Viewpoint+15.1...
5837112 Jul 2016 @ 12:47 PDTgarrett@data-design.comTeradata StudioTopicTD Studio data transfer unexpected tokenI'm creating a test for transfering data using TD Studio 15.10.11 running on an iMac OS X 10.11.5 with lots of memory and disk. On the same machine, I have a TD VM Express 1TB version 14.10 O...
5837012 Jul 2016 @ 12:07 PDTHustlerDatabaseReplyHigh Skewfactor inspite of even distributionHi all,   Does Skew factor affect the backup time?
5836912 Jul 2016 @ 10:47 PDTN_RaghuConnectivityTopicOLEDB Driver of TD15.10Are there any plans to release oledb driver for TD 15.10? Because I have SSIS packages that were developed with previous OLEDB version and those SSIS packages are crashing when I open in visual stu...
5836812 Jul 2016 @ 10:13 PDTfeinholzToolsReplyTPT output from ODBC includes Indicator Bytes?Can you look at the content of the error table and make sure the rows are placed in the error table due to the column that you defined as INTEGER? And let me know the error code?  

Pages