18 | 17 Feb 2015 @ 03:35 PST | Database | Reply | Spool Space | Thanks Dieter,Now i am clear.
|
17 | 17 Feb 2015 @ 11:43 PST | Database | Reply | Spool Space | Thanks,so dropping unwanted permanent tables will give more spool space right ?
|
16 | 13 Feb 2015 @ 01:33 PST | Database | Topic | Spool Space | Hi,
I read "unused Perm space is spool space" in one document.
My question was when we get "No spool space" error while processing the query ,if we d... |
15 | 23 Oct 2014 @ 06:12 PDT | Database | Topic | Load Different DATE formats into Teradata | Hi,
I have a requirement to load different date formats into teradata(Format MM-DD-YYYY HH:MM:SS) ,what is the transformation logic to handle different type of formats
|
14 | 18 Oct 2014 @ 12:15 PDT | Database | Reply | DML through multi table view | Thank you Dieter
|
13 | 17 Oct 2014 @ 07:17 PDT | Database | Topic | DML through multi table view | Hi,
I was trying to insert record into one of the base table through multi table view,it is giving error saying "View may not be used for insert/update/delete".but same ins... |
12 | 18 Sep 2014 @ 09:39 PDT | Database | Reply | Dynamic partition elimination | Thanks for the info,still i am not clear can you give one example.When DPE will occur and when static partition elimination will occur.
Thanks in advance
|
11 | 18 Sep 2014 @ 09:32 PDT | Database | Topic | Character set | Hi,
What is the differnce between unicode and latin character set.How can we choose the character set while creating table.Is there any way to convert unicode characters into Latin.... |
10 | 18 Sep 2014 @ 09:25 PDT | Database | Topic | Locking the table | Hi,
I have a requirement,i have to run multiple SQL statements but i need to make sure no one can access the table while running these sqls.How i can achieve this.
Ex:
BT
se... |
9 | 12 Sep 2014 @ 02:44 PDT | Database | Topic | Collect stats | Hi
I have a requirement where I have to load like below,
Table A->intermediate table 1->intermediate table 2->table B
running above statements between BTET.have to collec... |
8 | 12 Sep 2014 @ 02:25 PDT | Database | Topic | Dynamic partition elimination | Hi,
I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify
|
7 | 12 Sep 2014 @ 02:25 PDT | Database | Topic | Dynamic partition elimination | Hi,
I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify
|
6 | 21 May 2014 @ 08:43 PDT | General | Topic | Space Allocation | Hi,
Can any one explain how space will be allocated for PERM,SPOOL,TEMP space with example in teradata.
Thanks,
Sravanthi
|
5 | 21 May 2014 @ 08:38 PDT | General | Reply | Number of bytes-BIGINT | Thanks for the clarification.
|
4 | 15 May 2014 @ 09:29 PDT | General | Topic | Number of bytes-BIGINT | Hi
I have doubt in allocation of bytes ,
For example there is one BIGINT column having 2 values 1,10000.My doubt is for both the values terdata assign 8 bytes(as BIGINT occupies 8 bytes) o... |
3 | 12 May 2014 @ 08:19 PDT | General | Reply | Convertion from SQL Server to Teradata | Used convert(varchar(30),cast([column_name] as varbinary(30)),1)
Getting correct value in teradata.
Thanks for the help.
|
2 | 17 Apr 2014 @ 09:22 PDT | General | Topic | Convertion from SQL Server to Teradata | Hi,
We are loading data from SQL server to Teradata using informatica.our issue is,there is one timestamp column(contain binary data) in sql server.we need to load into... |
1 | 15 Apr 2014 @ 08:06 PDT | General | Topic | When we need to collect stats on table | Hi,
we are loading data into teradata through informatica using TPT load connection.Our load type is truncate and reload every month.
1)Do i need to collect the stats on... |