#DateForumTypeThreadPost
54403 Aug 2016 @ 04:05 PDTGeneralReplyConcatenate Hi, You want to populate the column names OR column values?  
54330 Jul 2016 @ 04:56 PDTAsterReplyRunning ncluster_export fails with uppercase objectsHi, 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  
54227 Jul 2016 @ 07:40 PDTDatabaseReplyMultiload 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...
54127 Jul 2016 @ 03:43 PDTAnalyticsReplyQUERY IN ASTER Go through this article to get started with Aster: http://developer.teradata.com/aster/articles/using-aster-express-act-1
54027 Jul 2016 @ 03:14 PDTDatabaseReplyNeed to get View Column derivation info from teradataYou 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...
53927 Jul 2016 @ 01:50 PDTDatabaseReplyNeed to get View Column derivation info from teradataI 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 ...
53827 Jul 2016 @ 01:43 PDTDatabaseReplyTPT ODBCThis has already been answered at https://forums.teradata.com/forum/tools/tpt17122-error-unable-to-connect-to-data-sourceoracle-using-tpt-script
53727 Jul 2016 @ 01:39 PDTGeneralReplyHow to search multiple columns for specific texttry this: Select cm# from cm_databse where id1 = 'dl123' OR id2 = 'dl123' OR id3 = 'dl123'  
53627 Jul 2016 @ 01:36 PDTDatabaseReplyHow to Write the correct syntax for JoinHi, 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 ...
53527 Jul 2016 @ 01:29 PDTDatabaseReplyWhat is difference between Redistribution of rows and Duplication of small table in AMPsTeradata has only one spool space, the rows are duplicated / redistributed to spool space.
53427 Jul 2016 @ 01:26 PDTUDAReplyCollect Stats n Refresh StatsThe 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...
53327 Jul 2016 @ 01:23 PDTDatabaseReplyHelp Combing Two QueriesCan you share the DDLs of both these tables?
53226 Jul 2016 @ 03:10 PDTGeneralReplyHow to search multiple columns for specific textDo 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.
53126 Jul 2016 @ 02:57 PDTDatabaseReplyhow to handle Null values in FASTloadCan you try using a single space empty string  in all these nullif literals? 
53025 Jul 2016 @ 07:10 PDTDatabaseReplyFastloadIt 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.  
52925 Jul 2016 @ 06:37 PDTDatabaseReplyFastloadThese 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...
52825 Jul 2016 @ 06:27 PDTDatabaseReplyMerge into operationMerge 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...
52725 Jul 2016 @ 06:14 PDTDatabaseReplyFastloadYou 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...
52625 Jul 2016 @ 06:02 PDTDatabaseReplyFastloadThe 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...
52525 Jul 2016 @ 05:57 PDTDatabaseReplyHelp needed for understanding of space default behavior and limitations or rulesQ1- 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...
52425 Jul 2016 @ 05:52 PDTTeradata Database on VMWareReply"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...
52324 Jul 2016 @ 06:55 PDTDatabaseReplyMerge into operationYou can read this thread it will answer your question. http://datawarehouse.ittoolbox.com/groups/technical-functional/teradata-l/merge-with-nupi-index-4742107
52224 Jul 2016 @ 06:44 PDTDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GBTeradata 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...
52124 Jul 2016 @ 06:30 PDTAsterReplyAster database/schema/table space managementHi, 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...
52024 Jul 2016 @ 06:08 PDTToolsReplyInstalling Teradata ODBC on AIXHi, 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...

Pages