423 | 11 Mar 2013 @ 02:05 PDT | Database | Reply | LENGTH() function in bteq | Yes, CHARACTER_LENGTH will surely work.
|
422 | 11 Mar 2013 @ 02:01 PDT | Database | Reply | Unique primary key voilation Error | And the error is .... ? Some detials might help.
|
421 | 11 Mar 2013 @ 02:01 PDT | Database | Reply | how to create a user, database and table in sql assistant? | I dont think they are default ones .... better ask who granted them. :)
|
420 | 11 Mar 2013 @ 01:58 PDT | Database | Reply | Procedures Calling Procedures with Dynamic Result Sets (from TD notes) | There has to be some error description, code .... ?
|
419 | 11 Mar 2013 @ 01:55 PDT | Database | Reply | Is it good to creating SET table with UPI or NUPI and why..? | What is going to be the use of the table? What type of data is expected? Is it going to be History Handled? Is it going to be loaded near real-time? Will it be used in joins majority of the times? ... |
418 | 11 Mar 2013 @ 01:52 PDT | Private Forum |
417 | 03 Mar 2013 @ 02:57 PST | Tools | Reply | SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04 | Can you share more details .... like if you are using VMWare, or its a local server or on a network .... etc? |
416 | 03 Mar 2013 @ 02:56 PST | Database | Reply | FastLoad And Query Access | Will try it out .... never seen that .... may be probability is very low.
Good info Dieter! :) |
415 | 03 Mar 2013 @ 02:53 PST | Database | Reply | Table partitioning on TIMESTAMP(3) in Teradata 13 | Perfect .... Dieter :) |
414 | 02 Mar 2013 @ 05:06 PST | Database | Reply | FastLoad And Query Access | No it is not possible.
Whereas, normally table is dropped and created within a FL script.
HTH!
|
413 | 02 Mar 2013 @ 05:03 PST | Database | Reply | Sybase To Teradata..... | Thorough analysis and documentation should be done on them and depending on the available skill-set .... the logic should be transformed either to a SP in Teradata (most of the cases) or for a few ... |
412 | 02 Mar 2013 @ 04:59 PST | Database | Reply | Will volatile tables be dropped? | Are you using dynamic SQL to create VTs?
|
411 | 02 Mar 2013 @ 04:56 PST | Database | Reply | Table partitioning on TIMESTAMP(3) in Teradata 13 | Can be done using follows:
PARTITION BY RANGE_N(ts1 BETWEEN
TIMESTAMP '0001-01-01 00:00:00.000000+00:00' AND
TIMESTAMP '9999-12-31 23:23:59.999999+00:00'... |
410 | 02 Mar 2013 @ 03:53 PST | UDA | Reply | Importing delimiter text file!!!!!!!! | This is a typical case of complex delimited file scenario:
If you take " as your delimiter, you will have following columns:
null
12345
,
ABCD
,
STU,GHj
,
... |
409 | 02 Mar 2013 @ 03:46 PST | General | Reply | Did anyone store RDF data (Resource Description Framework) data on Teradata ? | Isnt the RDF data XML files?
|
408 | 02 Mar 2013 @ 03:38 PST | Tools | Reply | SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04 | Can you try re-installing ODBC driver?
|
407 | 02 Mar 2013 @ 03:37 PST | Tools | Reply | What tool for SP development? | SQL Assistant .... or a Notepad.
|
406 | 02 Mar 2013 @ 03:34 PST | Database | Reply | Use of a Primary Index | Documentation :)
|
405 | 02 Mar 2013 @ 03:31 PST | Database | Reply | Difference between Create table Statements | The only difference is that .... in option 1 you have a leverage to tweak/select (correct) index.
I have seen scenarios where option 2 takes hours to process data .... and if you go with o... |
404 | 04 Feb 2013 @ 02:43 PST | Analytics | Reply | Using different date formats | Teradata stores the date internally as an integer, so it doesnt affect the comparison or processing speed.
|
403 | 04 Feb 2013 @ 01:40 PST | General | Reply | Does COMPRESS help performance? | Lesser data to fetch, store, process .... meaning .... lesser bytes to read, write, access .... less I/Os which is very expensive operation. CPU time may increase but it is much efficient as compar... |
402 | 03 Feb 2013 @ 11:42 PST | Database | Reply | New user. Tyring to figure out how to group two statements | Duplicate post.
|
401 | 03 Feb 2013 @ 12:14 PST | General | Reply | How to check which data has an error | You can export the error table to see the row-content which has error.
Regards, Adeel
|
400 | 03 Feb 2013 @ 12:09 PST | General | Reply | How to find status Difference using date field | Duplicate post.
|
399 | 03 Feb 2013 @ 12:05 PST | General | Reply | Why does it feel like Teradata is years behind? | In my opinion .... its a matter of perspective.
I agree to some points mentioned by Nezoic, but again .... it all depends on the way you at things.
Teradata Engineering is contino... |