23 | 04 Mar 2016 @ 07:27 PST | Database | Reply | How do i write qualify rank() over (partition.....question | how to get dense rank in teradata?
is there any dense_rank() function available in teradata
|
22 | 04 Mar 2016 @ 02:36 PST | Tools | Reply | Casting Zoned decimal into readable decimal |
sel cast(field as format '99'')
output should be 12
10
error--combination... |
21 | 28 Apr 2015 @ 08:12 PDT | General | Reply | Timestamp with time zone | Hi
how to convert one time zone to another tome zone with day light saving in TERADATA.
ex-from CET TO PST
Thanks in Adv
|
20 | 19 Jan 2015 @ 09:04 PST | Tools | Reply | Fast Export issue (Kindly Help) | Hi Team,
need help regarding teradata fast export. i am getting restart in progress please see bold letter in log file.
0003 .LOGTABLE ERROR_T.test;
0004 .DATEFORM ANSIDATE;
**** 11:3... |
19 | 19 Jan 2015 @ 08:52 PST | Teradata Applications | Reply | FastLoad process hang with concurrent sessions | Hi
i am using fast export.when i running in dev server its running fine but when i am running in SIT server the informatica session is in only running condition.
i saw the l... |
18 | 07 Nov 2014 @ 07:09 PST | Teradata Studio | Reply | Trying to import text file into volatile table using Teradata SQL Assistant |
Hi All,
I have the following issue.
insert into table.namevalues(?, ?, ?, ?)
my 4th column is timstamp(6) in TERADATA
1st i export that record fr... |
17 | 14 Oct 2014 @ 09:54 PDT | Teradata Applications | Reply | FastLoad process hang with concurrent sessions | hi
can any one tell me is it compolsoury that datatype of source file in informatica should be match with datatype of table in teradata
if i use fastload.
i am loading file to terad... |
16 | 04 Oct 2014 @ 10:37 PDT | Database | Reply | Multi-Value compression has increased the table size | hi
what is the max number of value per column that can be compressed using MVC in TD14.
|
15 | 26 Sep 2014 @ 08:57 PDT | Database | Reply | Remove characters after '-' in a string | Hi All,
I have the following date format in my source 2014-09-21 00:00:00.7563362.
my datatype in teradata is timestamp(6). i need o/p like 2014-09-21 00:... |
14 | 15 Sep 2014 @ 09:58 PDT | Database | Topic | HOW TO GET TIMESTAMP VALUE |
source date format
8/18/2014 3:55:45 PM
I am given as Timestamp(0) in TERADATA
e.g – DOJ Timestamp(0)
it is not working
I LOADING A FILE &nb... |
13 | 17 Aug 2014 @ 09:53 PDT | Training | Reply | Teradata 14 basics certification information | Hi rakesh,
I am also planning to do TD-14 basic certification. whatever you mention is right syllabus for TD-14 basic.
could you please send me the link where i get the syll... |
12 | 14 Aug 2014 @ 08:17 PDT | Training | Reply | Need help to find out Teradata certification material |
Hi ,
I am planning to do the Teradata certification .
Could you please send material for TEO 141-basic certification on email id -rajinformatica2014@gmail.com
&... |
11 | 13 May 2014 @ 06:35 PDT | General | Reply | default character set in teradata | hi
colname VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL
i want to make this col as nullable how to do this .can any one post the query.
|
10 | 02 May 2014 @ 09:43 PDT | Data Modeling | Reply | Using a PPI column in PI | hi
i have PI as colA and now the skew is 80%. i added one more col to that pi i.e my proposed pi is (colA,colB) AND the skew is 7%. is there any impact on downstream. like my table is ... |
9 | 18 Apr 2014 @ 08:36 PDT | Database | Reply | Skew Factor | thanks for reply
it is a stage table . is there any specific cases where we can't use timestamp as PI
|
8 | 18 Apr 2014 @ 09:56 PDT | Database | Reply | Skew Factor | hi
can we take timestamp column as PI. HERE is my table structure can you guide me col should/shouldn't be take as PI.
SVC_DSPCH_ID VARCHAR(50) CHARACTER SET UNICODE NOT CASESPECIFIC,
... |
7 | 17 Apr 2014 @ 06:25 PDT | Database | Reply | How to reduce skew factor on stage tables with NoPI? | thanks for ur response
|
6 | 17 Apr 2014 @ 06:24 PDT | General | Reply | No Spool space error | hi
it is incremental table
|
5 | 16 Apr 2014 @ 08:28 PDT | Database | Reply | How to reduce skew factor on stage tables with NoPI? | hi
can you tell about the use of collect stats in after choosing new pi
//taj
|
4 | 16 Apr 2014 @ 08:26 PDT | Database | Reply | How to reduce skew factor on stage tables with NoPI? | thanks krish for quick response
it is very helpfull for me .
|
3 | 16 Apr 2014 @ 08:19 PDT | General | Reply | No Spool space error | hi
i new to teradata, now i am working on to reduce skew. here is my details
initially my table has 2 PI having skew 60
now i create a table on tmp database with 3 PI which has skew 3.5 ... |
2 | 16 Apr 2014 @ 10:44 PDT | Database | Reply | How to reduce skew factor on stage tables with NoPI? | hi
can we take a column which is declare as compress(0) as PI column.
max how many column we can go for combination to find better pi for skew
|
1 | 15 Apr 2014 @ 08:44 PDT | Database | Reply | Skew Factor | hi
i am new to teradata, HOW REDUCE SKEW FACTOR IF IT IS >60 . IN TABLE I HAVE NUPI, SHALL I GO FOR COMBINATION OF COLUMN AS PI TO CHECK SKEW FACTOR . WHAT ARE OTHER APPROACH TO REDUCE SK... |