473 | 02 Feb 2014 @ 04:04 PST | Database | Reply | How can I install teradata express without VT support since I don't have windows version of teradata express download link? | Teradata express for windows has been not around for some time now, you can use VMWare image. It is available in different sizes (4GB 40Gb, 1TB).
|
472 | 02 Feb 2014 @ 04:02 PST | Database | Reply | How can I install teradata express without VT support since I don't have windows version of teradata express download link? | VT Support?
|
471 | 02 Feb 2014 @ 12:46 PST | Database | Reply | Space in the database | If the perm-space is zero, user usually fly off the planet.
Answer is B & C, as perm-space has nothing to do with data-access rather its for data-storage.
|
470 | 02 Feb 2014 @ 12:37 PST | Database | Reply | Converions of timestamp to FORMAT 'MM/DD/YYYYBHH:MI:SS' |
You have 1 extra ')' just before AS TIMESTAMP(0):
Correct:
CAST(SUBSTRING (CAST (A.DW_LOAD_TMP AS VARCHAR(19)) ,1,19) AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SS... |
469 | 02 Feb 2014 @ 12:29 PST | Database | Reply | Teradata Spool issue in Recursive issue | What exactly do you mean by 'While as per requirement no duplicate allowed in the resiliation column.'? Duplication of values as a chunk or individual values?
|
468 | 02 Feb 2014 @ 12:08 PST | Database | Reply | SQL Workaround | Sounds like a very nice project.
I would start by analyzing each query and noting about underlying tables, data volumes, PIs, PPIs, Joins, Joining columns, Data-types of joining columns, e... |
467 | 02 Feb 2014 @ 12:03 PST | Database | Reply | Can 'INSERT INTO' statement handle duplicates? | Which underlying tables are you using .... SET or MULTISET?
|
466 | 02 Feb 2014 @ 12:02 PST | Database | Reply | Selection of Primary index |
On a very high level, for data loading you need to select column(s) giving you the unique values for most of data .... for accessing the data you need to select column(s) causing minimum re-dist... |
465 | 01 Feb 2014 @ 11:54 PST | Database | Reply | Formatting CURRENT_TIMESTAMP | You dont need to cast to varchar/char if you are connected via CLI .... it is required on ODBC connectivity.
|
464 | 01 Feb 2014 @ 11:26 PST | Database | Reply | UDF in teradata | Source code of UDF is a C++ code or SQL code, binary file must be the compiled form. What is the source of this .o file?
|
463 | 01 Feb 2014 @ 11:24 PST | Database | Reply | Deadlocks whenusing Teradata with Informatica | How is your workflow arranged? Ideally it should be managed there to ensure flows having same target table are sequenced.
|
462 | 01 Feb 2014 @ 09:37 PST | Database | Reply | Near Real Time Stored Procedure Architecture Framework | Ideally, you need to bring in data in TD before you could get the benefits of SP. The name 'Near real-time architecture' suggests you should be using tpump to trickle the data from source t... |
461 | 01 Feb 2014 @ 09:23 PST | Database | Reply | Parsing Engine is taking long time to parse a query !!! | How are you managing the rights for users/roles?
|
460 | 01 Feb 2014 @ 01:08 PST | Tools | Reply | Teradata SQL Assistant 13.10 (ODBC version) - Download | SQL Assistant doesnt have seperate versions i.e. ODBC or .NET .... single version works for both.
Also, TDU 14.* will work just fine as they are downward compatible. In case you specifical... |
459 | 31 Jan 2014 @ 11:14 PST | General | Reply | arcmain download link | Your best bet is to contact your DBA.
|
458 | 31 Jan 2014 @ 11:12 PST | General | Reply | fs-ldm and tsys | I dont think you can get that information publically.
|
457 | 31 Jan 2014 @ 09:00 PST | Database | Reply | FORMAT option in create table | SQLA/ODBC converts the formats to local system's format. You can still view the actual data stored using BTEQ/CLI connectvity.
|
456 | 31 Jan 2014 @ 08:59 PST | Database | Reply | Please share any possibility approach with automated process for 2500+ Teradata tables. Urgent | And it would be better to start at the LDM level, to ensure consistency across all tables.
|
455 | 31 Jan 2014 @ 08:57 PST | Database | Reply | Query Optimisation | Intermediate tables seem the best option in this scenario. You havent shared row-counts/time its taking.
|
454 | 31 Jan 2014 @ 08:52 PST | Database | Reply | Generating Surrogate Key Using ROWNUM | Please share your DB.table-names & current/expected row-counts to better propose a solution.
|
453 | 31 Jan 2014 @ 08:51 PST | Database | Reply | Question regarding Fastload | Its a limitation of FL, you need to have a newline character at the end of file. What is the source of your file or are you fetching it from some DB yourself?
|
452 | 31 Jan 2014 @ 08:49 PST | Database | Reply | Sql help | Can you also share the sample output against the sample values, to better understand what you require.
|
451 | 31 Jan 2014 @ 08:47 PST | Database | Reply | Generate SurrogateKey with a huge table | Is there any compulsion in using ROW_NUMBER?
From my experience, CSUM and ROW_NUMBER can cause the response time to slow-down considerably.
For smaller tables they work fine, but ... |
450 | 22 Aug 2013 @ 04:41 PDT | Database | Reply | Migrating From Oracle To Teradata Help With DDL Generation | If not willing to use any other software .... no other option. You must do data-type conversion and index changes manually.
HTH!
Regards.
|
449 | 22 Aug 2013 @ 04:37 PDT | Database | Reply | Distinct in Case clause | Please share the desired output of the dataset as well.
|