544 | 03 Aug 2016 @ 04:05 PDT | General | Reply | Concatenate | Hi,
You want to populate the column names OR column values?
|
543 | 30 Jul 2016 @ 04:56 PDT | Aster | Reply | Running ncluster_export fails with uppercase objects | Hi,
In order to make the case sensitive use of table name the qoutes should be escaped like below:
./ncluster_export -h 192.168.1.100 -U xxx -w xxx -c \"TesT\" outputFile
|
542 | 27 Jul 2016 @ 07:40 PDT | Database | Reply | Multiload |
Hi,
There are a few differnces between Mload Import task and delete task.
In the delete task there is no acquisition phase, only application phase is used to delete rows. So th... |
541 | 27 Jul 2016 @ 03:43 PDT | Analytics | Reply | QUERY IN ASTER | Go through this article to get started with Aster:
http://developer.teradata.com/aster/articles/using-aster-express-act-1
|
540 | 27 Jul 2016 @ 03:14 PDT | Database | Reply | Need to get View Column derivation info from teradata | You will have to show the view definition to get the source of Cal_Val.
If you need this info to automate something, you can use show view, extract tablename in some variable and use that variable... |
539 | 27 Jul 2016 @ 01:50 PDT | Database | Reply | Need to get View Column derivation info from teradata | I dont see much difference what you already have, except you want to use table name with column names.
You can use the table alias for that as follows:
repalce view DBV.Myview as locking table ... |
538 | 27 Jul 2016 @ 01:43 PDT | Database | Reply | TPT ODBC | This has already been answered at
https://forums.teradata.com/forum/tools/tpt17122-error-unable-to-connect-to-data-sourceoracle-using-tpt-script
|
537 | 27 Jul 2016 @ 01:39 PDT | General | Reply | How to search multiple columns for specific text | try this:
Select
cm#
from cm_databse
where id1 = 'dl123' OR id2 = 'dl123' OR id3 = 'dl123'
|
536 | 27 Jul 2016 @ 01:36 PDT | Database | Reply | How to Write the correct syntax for Join | Hi,
The first thing is spool space issue occurs mostly when there is a product join in the query. As you are joining the store table with Transactions table, it may go for a product join. In your ... |
535 | 27 Jul 2016 @ 01:29 PDT | Database | Reply | What is difference between Redistribution of rows and Duplication of small table in AMPs | Teradata has only one spool space, the rows are duplicated / redistributed to spool space.
|
534 | 27 Jul 2016 @ 01:26 PDT | UDA | Reply | Collect Stats n Refresh Stats | The first thing is collect only the stats required, not all stats. It will save a lot of time and provide you performance.
As stats collection after every insert will take time and prolong the bat... |
533 | 27 Jul 2016 @ 01:23 PDT | Database | Reply | Help Combing Two Queries | Can you share the DDLs of both these tables?
|
532 | 26 Jul 2016 @ 03:10 PDT | General | Reply | How to search multiple columns for specific text | Do you mean you want to write something like:
where cm# IN (1,3)
OR
Where Id1 = 'dl123' or id2 = 'dl321' or cm# IN (1,3)
Please clarify.
|
531 | 26 Jul 2016 @ 02:57 PDT | Database | Reply | how to handle Null values in FASTload | Can you try using a single space empty string in all these nullif literals?
|
530 | 25 Jul 2016 @ 07:10 PDT | Database | Reply | Fastload | It is the target table that gets locked, error tables are available to analyse the issues.
Can you share the falstload job logs to understand the issue properly.
|
529 | 25 Jul 2016 @ 06:37 PDT | Database | Reply | Fastload | These error tables are dropped by default if there are no error records in these error tables.
The tables are retained only when the there are rows in error tables.
Duplicate records are si... |
528 | 25 Jul 2016 @ 06:27 PDT | Database | Reply | Merge into operation | Merge Statement requires Primary Key in its condition regardless of Index.
If it is not possible to define a primary key for the table, you can not use merge syntax.
you can try Upsert syntax ins... |
527 | 25 Jul 2016 @ 06:14 PDT | Database | Reply | Fastload | You can see the entries in error tables, but right now you have issue in your script, that's why error tables are not accessible.
You can use these queries to see the data in error tables:
se... |
526 | 25 Jul 2016 @ 06:02 PDT | Database | Reply | Fastload | The load is paused when there is some issue in the script. Error tables only capture the issues in data.
To rectify the issue, go through the Fastload script log. You can create the loag file as f... |
525 | 25 Jul 2016 @ 05:57 PDT | Database | Reply | Help needed for understanding of space default behavior and limitations or rules | Q1- If you do not specify spool and temp space, it will inherit the spool and temp space of parent that is A1 so the spool and temp space for A11 will be:
Spool = 100 GB
Temp = 100 GB
Q2- This w... |
524 | 25 Jul 2016 @ 05:52 PDT | Teradata Database on VMWare | Reply | "How to download TTU for fixing the bteq issue on mac" | Hi,
We faced this issue on AIX, the issue ocuurs due to incorrect settings and sequence of environment variables.
Follow the environment variables instructions in the installation of TTU. Otherwi... |
523 | 24 Jul 2016 @ 06:55 PDT | Database | Reply | Merge into operation | You can read this thread it will answer your question.
http://datawarehouse.ittoolbox.com/groups/technical-functional/teradata-l/merge-with-nupi-index-4742107
|
522 | 24 Jul 2016 @ 06:44 PDT | Database | Reply | Problems installing in TDExpress15.00.02_Sles11_40GB | Teradata 15.10 VM can be downloaded from here:
http://downloads.teradata.com/download/database/teradata-express-for-vmware-player
You can check the patch level from VM if it is 2 then you can eas... |
521 | 24 Jul 2016 @ 06:30 PDT | Aster | Reply | Aster database/schema/table space management | Hi,
This is infact a very interesting question. I have gone through all the Manuals of Aster but didn't find any rules for space management. The database are created without any parameters for... |
520 | 24 Jul 2016 @ 06:08 PDT | Tools | Reply | Installing Teradata ODBC on AIX | Hi,
You can get these components individually from Teradata At Your Service i.e. https://tays.teradata.com/
If your customer do not have an account at Tays, they can get an account from Tera... |