Pages
![]() |
...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;
30 Aug 2016
| 2 comments
,
|
![]() |
Hi, DECLARE var_a VARCHAR(10); DECLARE var_b VARCHAR(10); DECLARE var_c VARCHAR(10);
DECLARE crsr CURSOR FOR
22 Aug 2016
,
|
![]() |
why I am getting a syntax error?
17 Aug 2016
| 1 comment
,
|
![]() |
Hi all,I will try to explain this in the best way possible.
04 Aug 2016
| 3 comments
,
|
![]() |
I've a data in the following format -
31 Jul 2016
| 2 comments
,
|
![]() |
I am working on FETCH STATEMENT inside CURSOR. I need to convert a SQL server script into Teradata. SQL SERVER input:---------------------------------------
28 Jul 2016
,
|
![]() |
Error : TPT_INFRA: TPT02638: Error: Conflicting data length for column(5) - STATE. Source column's data length (16) Target column's data length (8). EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement
Code :
06 Jul 2016
| 3 comments
,
|
![]() |
Hello Every One, SYR = 201401 , SYR = 201402 , SYR = 201403 , SYR = 201404
CREATE MULTISET TABLE xyz ,NO FALLBACK ,
05 Jul 2016
| 2 comments
,
|
![]() |
|
![]() |
I have a parameter in a report (Report Builder 3.0) called REPORT_FILTER. This parameter has 4 available values. The labels are (1) Home Group, (2) Home Branch, (3) Other Group, and (4) Other Branch. The corresponding values are 1, 2, 3, and 4.
13 Jun 2016
,
|
![]() |
Hi,
10 Jun 2016
| 1 comment
,
|
![]() |
If TPT Attributes
09 Jun 2016
| 7 comments
,
|
![]() |
I am very new to the Teradata world. Have much interest to learn Teradata.
04 Jun 2016
| 5 comments
,
|
![]() |
03 Jun 2016
| 29 comments
,
|
![]() |
This article will introduce you to the new user experience provided by Teradata Studio's Administration Perspective; an improved interface for creating and modifying database objects.
03 Jun 2016
| 17 comments
,
|
![]() |
For a Fortune 50 Banking Company. W2 or corp-to-corp. Local candidates preferred but those willing to relocate will be considered. Manager would like to interview as soon as possible. Must have hands on experience with SQL development in Aster environment
02 Jun 2016
,
|
![]() |
I've got this error: Teradata execute: Numeric overflow occurred during computation.
01 Jun 2016
| 1 comment
,
|
![]() |
Hi All, Mar 22, 2016 12:06:35 PM
31 May 2016
| 1 comment
,
|
![]() |
Bonsoir , je voudrais installer teradata sur mon ordinateur sachant que j'ai windows 10 . est ce que c'est possible ? si oui , que je-dois faire ? Merci de me préciser les étapes à suivre pour l'installer sur ma machine . Merci Beaucoup
26 May 2016
| 4 comments
,
|
![]() |
Hi ,
26 May 2016
,
|
![]() |
|
![]() |
I am trying to use XMLAGG to transpose the row-wise data to comma separated value in Teradata 15. Its working fine with English (LATIN character set) characters. But while I am using other characters (Unicode character set) I am getting 'string contains untranslatable character' error.
16 May 2016
| 3 comments
,
|
![]() |
|
![]() |
Hello,
28 Apr 2016
| 2 comments
,
|
![]() |
Hi,
18 Apr 2016
| 5 comments
,
|
![]() |
I have a SQLSERVER 2012 database running on a Windows Server 2012 platform. I have installed the Microsift Connector for Attunity Version 2.0 and in SSIS I now have Teradata Source and Destination tools available. I have created a connector to the database and table I which to use in my SSIS package. The connector works and it allows me to preview the
15 Mar 2016
| 1 comment
,
|
![]() |
Is there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table.
10 Mar 2016
| 1 comment
,
|
![]() |
|
![]() |
|
![]() |
i tried making two sessions in fasload 1st got passed with inserion and 2nd didnt showed any such behaviour.
06 Mar 2016
| 1 comment
,
|
![]() |
|
![]() |
There are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats where the information for the stats used to get stored.i'm giving the below query to find that info regarding no of rows in a table or average row size etc.
27 Feb 2016
| 1 comment
,
|
![]() |
Untitled Page I have a data set in oracle (img1 in attachment) ww_id fmly_nm given_nm jnj_supvr_ww_id 000000034654 CLARK LISA
25 Feb 2016
| 4 comments
,
|
![]() |
I am facing an issue in executing below scritp through fast load utility for tab delimited .txt file.
24 Feb 2016
| 4 comments
,
|
![]() |
This is the MYSQL query, now I need this below dynamic query to be execute in TERADATA SQL.
set l_sql=concat('SELECT max(',l_rid_col,'), MAX(cid) INTO @c2, @c3 FROM ',p_database,'.',p_table); And this update query:
23 Feb 2016
| 1 comment
,
|
![]() |
Hi I have just installed Teradata in my local Machine.
12 Feb 2016
| 3 comments
,
|
![]() |
We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we can experiment to make this load any more faster ? The record number is a bit high so takes around significant time.
11 Feb 2016
| 1 comment
,
|
![]() |
|
![]() |
Hi,
26 Jan 2016
| 3 comments
,
|
![]() |
The OBIEE Sample Application is a fully functioning OBIEE environment available on a VM. It is self-contained in that demo applications can be run against data stored on the VM. It is possible to modify the VM so that external data can also be accessed and shown in a demo or used for testing. This article shows how to mod
25 Jan 2016
| 2 comments
,
|
![]() |
Aster AppCenter provides the citizen data scientist the ability to run a different type of analytic.
25 Jan 2016
,
|
![]() |
Hi All,
20 Jan 2016
| 3 comments
,
|
![]() |
Dear all,
11 Jan 2016
| 3 comments
,
|
![]() |
Hi All ,
08 Jan 2016
,
|
![]() |
Error Using teradata client for centos 6/7 php/python/unixODBC
29 Dec 2015
,
|
![]() |
Hi All -
02 Dec 2015
| 1 comment
,
|
![]() |
I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)
21 Nov 2015
| 1 comment
,
|
![]() |
Community Edition is a SUSE Linux Enterprise Server (SLES) operating system and Teradata Database packaged into a virtual container that runs in a VMware vSphere ESXI virtualized environment on third-party hardware. Community Edition software consists of a template and associated property files and scripts. When a Community Edition virtual machine is deployed, it operates as a fully functional instance of the configured Teradata Database. Once deployed by the VMware administrator, Community Edition can be used to evaluate Teradata Virtual Machine and the Teradata Database.
Note: You must have administrative privileges on the destination VMware environment to install and configure Community Edition virtual machines.
12 Nov 2015
,
|
![]() |
Dear All, Need help with below situation....
12 Nov 2015
| 2 comments
,
|
![]() |
I am trying to understand how Datastage interacts with Teradata in Immedaite mode. During my testing, I created a Datastage job with TD connector as source and destination to just select from one table and load into another table.
09 Nov 2015
,
|