378 | 21 Oct 2008 @ 09:11 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | "- (n) fastload target table will consist column name FIELD1, ..., FIELD235 where their type are varchar(200)."1. Are those fields really 200 byte each or is it just "i don't know/care about the ac... |
377 | 20 Oct 2008 @ 12:43 PDT | Database | Reply | Converting Timestamp to Date - Translation from Oracle Syntax | trunc -> cast as datenvl -> coalescecoalesce(cast(a11.AUTHORIZED_DATE as date), DATE '4712-12-31')Dieter |
376 | 20 Oct 2008 @ 12:41 PDT | Analytics | Reply | About PE | SQL Reference: Functions and OperatorsChapter 12: Hash-Related FunctionsHASHAMPExample 1If you call HASHAMP without an argument, it returns one less than the maximum number ofAMPs on the system.SEL... |
375 | 18 Oct 2008 @ 07:25 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | "2. fastload to target(n) table where the target is not partitioned and no index (since i can determine the index, but is it possible to have NUPI in fastload?)."Each and every table in Teradata al... |
374 | 15 Oct 2008 @ 12:18 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | 40.000*40.000 = 1.600.000.000 rows/dayThat's a lot for a small 32 AMP system: 50.000.000/AMP/dayHopefully "summarizing" reduces that number significantly, otherwise you run out of space within a fe... |
373 | 15 Oct 2008 @ 11:48 PDT | Analytics | Reply | AMPCHECK | As long as there's no AMP down, there will be no difference.But if an AMP is down and the job continues it will be slower, of course.Dieter |
372 | 15 Oct 2008 @ 11:39 PDT | Database | Reply | Compression In Teradata | Teradata uses a "Dictionary Compression" storing a list of compressed values within the table header and just a bit combination indicating the actual value within each row.You'll find all the detai... |
371 | 15 Oct 2008 @ 11:34 PDT | Database | Reply | rowkey | Joe is right.rowhash + uniqeness value -> ROWID (pre-V2R5)partition# + rowhash + uniqeness value -> ROWKEY (V2R5+)But usually everyone is still using the term ROWID instead of ROWKEY :-)Dieter |
370 | 14 Oct 2008 @ 04:12 PDT | Tools | Reply | Tpump performance | Each and every table in Teradata always has a Primary Index and an Insert is always using it.Dieter |
369 | 14 Oct 2008 @ 04:04 PDT | Database | Reply | Service not starting for 12.0 DB | Check if there's an old version of terasso.dll (wincli32.dll/tdusr32.dll) within \windows\system32 instead of \Program Files\NCR\Teradata Client\cliv2Dieter |
368 | 14 Oct 2008 @ 03:56 PDT | Database | Reply | "DBS CRASHED OR SESSIONS RESET." error when using bteq on Solaris | Based on DNS/hosts "dsserver" might resolve to a different (invalid) ip-address.Try to "ping dsservercop1" to check if it's the correct ip-address.Dieter |
367 | 14 Oct 2008 @ 03:52 PDT | Connectivity | Reply | Install Teradata SQL Assistant | You didn't specify on which OS you tried to install it. If it's on a 64-bit Windows, then the error is self-explaining.Else ...Btw, 7.1 is a quite old version, try 12 from the demo version instead ... |
366 | 14 Oct 2008 @ 03:38 PDT | UDA | Reply | Timestamp with a value of "2008-07-07 16:41:60" | The built-in function TIME is a FLOAT which is just formatted to look like a time. As a float it's following rounding rules, thus a value greater than xx:xx:59.50 will be rounded to xx:xx:60It's no... |
365 | 13 Oct 2008 @ 01:44 PDT | Database | Reply | Service not starting for 12.0 DB | Of course it's running, why don't you simply try to logon?Dieter |
364 | 11 Oct 2008 @ 09:43 PDT | Database | Reply | Service not starting for 12.0 DB | Hi Rajesh,this looks ok, there should be some events following immediately with a source "Teradata" and they will tell you, if it started successfully or failed to start. But as already mentioned, ... |
363 | 10 Oct 2008 @ 01:37 PDT | Database | Reply | Service not starting for 12.0 DB | Hi Rajesh,the recond service is just kicking off the start of Teradata and then stops.So your Teradata is probably already running, AFAIR there's a small tool to start/stop Teradata within the menu... |
362 | 10 Oct 2008 @ 01:33 PDT | UDA | Reply | Volatile table in Mainframe | A volatile table is always created within the user, as the error message implies.If you check the Messages manual you'll find:Explanation: Volatile tables are associated with thelogin user. This er... |
361 | 09 Oct 2008 @ 05:00 PDT | Database | Reply | elementary question | Why didn't you just try your Oracle query?ROW_NUMBER is Standard SQL and available in Teradata since several years. There's even an extension for filtering the result of the OLAP-function, similar ... |
360 | 02 Oct 2008 @ 03:53 PDT | Database | Reply | seeking Teredata DB paging solution | SQL Server introduced ROW_NUMBER in SS2005, but Teradata did it some years earlier in V2R4.Dieter |
359 | 02 Oct 2008 @ 03:49 PDT | Database | Reply | Query Tuning | 1. Replace the NOT IN with a NOT EXISTS, because one of the columns is NULLable:AND p.prod_id not in (select prod_id from dp_dedw_rep.RepTbl_RecurProducts)-> AND NOT EXISTS (select * from dp_ded... |
358 | 20 Sep 2008 @ 04:10 PDT | Database | Reply | raw disks and error messages | Of course a new AMP must initialize it's filesystem. It's done through vprocmanager's initvproc (for a single AMP) or a sysinit (for all AMPs).I don't know what you're actually trying to achieve (h... |
357 | 19 Sep 2008 @ 03:48 PDT | Database | Reply | Linking a Table name to a table Id | I don't know if it's possible to change showblocks output, but you can change the hex tableid to a decimal: HASHBUCKET(SUBSTRING(tableid FROM 2 FOR 1) || SUBSTRING(tableid FROM 1 FOR 1) (BYTE(4)))... |
356 | 18 Sep 2008 @ 05:25 PDT | Database | Reply | Linking a Table name to a table Id | You can change Ferret's default output format using the RADIX command:RADIX OUTPUT HEXDieter |
355 | 18 Sep 2008 @ 05:15 PDT | Database | Reply | raw disks and error messages | It must be a unformatted primary partition without assigned drive letter.Dieter |
354 | 18 Sep 2008 @ 05:09 PDT | Database | Reply | COLLECT STATS on combination of columns than single column | Hi Siree,submit a "diagnostic helpstats on for session" and explain the query. At the end of the explain there will be the recommendation of the optimizer.Dieter |