58392 | 13 Jul 2016 @ 04:26 PDT | crispo3 | Database | Topic | Advice on ELT process please | Hi,
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... |
58391 | 13 Jul 2016 @ 03:41 PDT | drmkd17 | Database | Reply | ALTER_PPI | Can I add a new range partition on a new column in an already created and populated table.
|
58390 | 13 Jul 2016 @ 03:26 PDT | drmkd17 | Database | Reply | extending MLPPI tables | Hi ,
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... |
58389 | 13 Jul 2016 @ 01:54 PDT | sachin.sebastian | Database | Reply | Calculate column value based on previous computed value | Here 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... |
58388 | 13 Jul 2016 @ 01:08 PDT | sharonn | Connectivity | Topic | Can 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... |
58387 | 13 Jul 2016 @ 12:24 PDT | WAQ | Database | Reply | Calculate column value based on previous computed value | Hi 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... |
58386 | 13 Jul 2016 @ 12:18 PDT | abhilash.dwbi@gmail.com | Teradata Studio | Reply | Need help on export file option in tereadata studio express | Hi 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 ... |
58385 | 12 Jul 2016 @ 11:02 PDT | drmkd17 | Viewpoint | Reply | Meaning of basic terms I see in Viewpoint | Thanks:)
|
58384 | 12 Jul 2016 @ 06:41 PDT | sallad | General | Topic | Teradata Forum Account Temporarily Blocked | I 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... |
58383 | 12 Jul 2016 @ 06:33 PDT | cvsanthosh | Database | Topic | Audit on Teradata | Hi,
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... |
58382 | 12 Jul 2016 @ 03:43 PDT | garrett@data-design.com | Teradata Studio | Reply | TD Studio data transfer unexpected token | CREATE SET TABLE SMS_Data_pi.dim_test_result ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
&nb... |
58381 | 12 Jul 2016 @ 03:06 PDT | fgrimmer | Teradata Studio | Reply | TD Studio data transfer unexpected token | Garrett, 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... |
58380 | 12 Jul 2016 @ 03:00 PDT | Ivyuan | Tools | Reply | Fastload - Error on piom GET ROW: 64 | Hi,
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 ... |
58379 | 12 Jul 2016 @ 01:36 PDT | garrett@data-design.com | Teradata Studio | Reply | TD Studio data transfer unexpected token | On another machine, MacBook Pro, I installed TD Studio 15.11. Same result.
|
58378 | 12 Jul 2016 @ 01:35 PDT | garrett@data-design.com | Teradata Studio | Reply | TD Studio data transfer unexpected token | This is Teradata to Teradata.
|
58377 | 12 Jul 2016 @ 01:25 PDT | fgrimmer | Teradata Studio | Reply | TD Studio data transfer unexpected token | Garrett, If you are doing a Data> Load on the table then you want to make sure you have chosen the correct EOL and delimeters.
|
58376 | 12 Jul 2016 @ 01:22 PDT | fgrimmer | Teradata Studio | Reply | TD Studio data transfer unexpected token | Garrett, Are you doing a Copy or Fast Load from a file?
|
58375 | 12 Jul 2016 @ 01:21 PDT | garrett@data-design.com | Teradata Studio | Reply | TD Studio data transfer unexpected token | Also, 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 ... |
58374 | 12 Jul 2016 @ 01:17 PDT | garrett@data-design.com | Teradata Studio | Reply | TD Studio data transfer unexpected token | I'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.
|
58373 | 12 Jul 2016 @ 01:14 PDT | fgrimmer | Teradata Studio | Reply | TD Studio data transfer unexpected token | Garrett, 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... |
58372 | 12 Jul 2016 @ 12:47 PDT | venkat3107 | Viewpoint | Reply | Meaning of basic terms I see in Viewpoint | http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TVPOINT15.11&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Viewpoint+15.1... |
58371 | 12 Jul 2016 @ 12:47 PDT | garrett@data-design.com | Teradata Studio | Topic | TD Studio data transfer unexpected token | I'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... |
58370 | 12 Jul 2016 @ 12:07 PDT | Hustler | Database | Reply | High Skewfactor inspite of even distribution | Hi all,
Does Skew factor affect the backup time?
|
58369 | 12 Jul 2016 @ 10:47 PDT | N_Raghu | Connectivity | Topic | OLEDB Driver of TD15.10 | Are 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... |
58368 | 12 Jul 2016 @ 10:13 PDT | feinholz | Tools | Reply | TPT 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?
|