All forum activity

#DateUserForumTypeThreadPost
5866722 Jul 2016 @ 12:07 PDTjmooneyToolsTopicInstalling Teradata ODBC on AIXHi, I am in need of installing Teradata ODBC on AIX 7.1. I have downloaded the AIX Teradata ODBC file.  According to it's read file: Prior to installing the "ODBC Driver ...
5866622 Jul 2016 @ 12:07 PDTFredDatabaseReplyDefaulting during Teradata table loading through fast load FastLoad supports changing default values from the source to NULL, but not the other way around.   MultiLoad / TPT UPDATE would allow you to specify a COALESCE or CASE expression as part of ...
5866522 Jul 2016 @ 09:34 PDTFredViewpointReplyLimit a role to only one Teradata system of several activeThe "Enable Systems" checkbox controls the list of systems for which you will be able to configure individual portlet permissions for the role. The Admin portlets currently do not h...
5866422 Jul 2016 @ 07:12 PDTsk8s3iDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousThanks Carlos! Appreciate it. 
5866322 Jul 2016 @ 06:50 PDTdnoethDatabaseReplyConsequential inserts into large fact table performing very slow inside stored ProcedureAs the first insert is fast and the following geting slower you might have a SET table with lots of rows per NUPI. And you seem to run those inserts sequentially, the first will be using FastPath ...
5866222 Jul 2016 @ 06:09 PDTVandeBergBDatabaseReplyConsequential inserts into large fact table performing very slow inside stored ProcedureCheck the performance of your complex source views, that SQL is going to be run.  I'm not sure how you'd use volatile tables here.  Can you post the DDL for the target table, SP a...
5866122 Jul 2016 @ 04:59 PDTagnit.chatterjee1988DatabaseReplyConsequential inserts into large fact table performing very slow inside stored Procedure1) Views will use the same PI as the base tables in joins. 2) I think it is in fact possible to use Volatile Tables in Stored Procedures.  3) For performance improvement you can have a look ...
5866022 Jul 2016 @ 04:55 PDTagnit.chatterjee1988DatabaseReplyVolatile Tables in MacrosYes possible.
5865922 Jul 2016 @ 04:40 PDTagnit.chatterjee1988DatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousWith period data type using EXPAND ON clause it might provide the necessary output.   Agnit.
5865822 Jul 2016 @ 04:32 PDTjuanalfonsoDatabaseReplyProblems installing in TDExpress15.00.02_Sles11_40GB In the end, I'll probably have to change to a Teradata Express 15.10... Is there a Teradata Express 15.10 available to download where SAP DS (the Server side) can work? And, if that...
5865722 Jul 2016 @ 04:32 PDTagnit.chatterjee1988DatabaseReplyMerge into operationI think it's possible. Don't such see any such constraints why it won't be possible. But got to mention all the tgt PI columns in the join condition. Agnit
5865622 Jul 2016 @ 04:18 PDTSoumyatgDatabaseTopicMerge into operationI am rewriting an insert statement which was taking lot of time, as a Merge statement. The target table is Multiset also it has a composite NUPI. the source may have non unique rows. Is it at all p...
5865522 Jul 2016 @ 04:01 PDTCarlosALDatabaseReplyHow to calculate minimum & maximum values based on a column only if the records are continuousHi. I overlooked the dates and didn't understand the logic you wanted. Adhering to your example, you can get the results you want:   BTEQ -- Enter your SQL request or BTEQ comman...
5865421 Jul 2016 @ 10:28 PDTSoumyatgDatabaseTopicConsequential inserts into large fact table performing very slow inside stored Procedure  Run_Id Check_Point Check_Point_Desc Records_Processed time_elapsed 16 201,607,122,102 1 Delete From    Xyz 110,013,266   0:...
5865321 Jul 2016 @ 09:07 PDTbranko.pAsterTopicAster database/schema/table space managementI'm having trouble allocating database space on aster when I create new db, schema or table. At what level can you allocate disk space (assuming at db level) and how can this be done? I'm u...
5865221 Jul 2016 @ 07:29 PDTzakywAnalyticsReplyCoverting Char to Datehi roy_soumya ya , i agree with the others , you can used function CAST for the convert char to date     
5865121 Jul 2016 @ 07:02 PDTzakywAnalyticsReplyHow to create churn data for customers by transaction in month?Hi Dieter  I want to Disscuss with you about Structure query in aster , how to create statement query in the aster ,  whether query in aster with the teradata is different or not ? ...
5865021 Jul 2016 @ 06:50 PDTzakywAnalyticsReplyQUERY IN ASTER BTW , one more master sorry  for the statement \bl\b' ,  what's the meaning of the statement above ?    please for your explaination TD Master    thank y...
5864921 Jul 2016 @ 06:10 PDTzakywAnalyticsReplyQUERY IN ASTER for example  this query have me create in the aster , whether for the statement is correct or not ?    CREATE TABLE sb7.zw_cc_payment_mon_201607 DISTRIBUTE BY HASH(msi...
5864821 Jul 2016 @ 04:23 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTOur documentation will describe examples, and we ship sample scripts with TPT. Look in the "samples" directory where TPT is installed.  
5864721 Jul 2016 @ 04:22 PDTfeinholzToolsReplyTPT Export vs Fast ExportYes, TPT supports the writing of data to multiple files. Just use the Export operator to extract the data from Teradata. Use the DataConnector operator as the file writer. Specify how many insta...
5864621 Jul 2016 @ 03:50 PDTfeinholzToolsReplyTPT - ScriptingThere is currently no way to force tdload to use a specific operator. (It is on the list for a future enhancement.) To force the use of a specific operator, you would need to write a script. (Al...
5864521 Jul 2016 @ 03:22 PDTIvyuanToolsReplyFloat data type export using Fast ExportHi, This is not related to FastExport utility. We can see this using BTEQ too. Is it Okay to use some other data types like decimal? Here is an example:  BTEQ -- Enter your SQL request or ...
5864421 Jul 2016 @ 02:52 PDTKKTDatabaseReplyVolatile Tables in MacrosSo can I put below code in SP and get result set out when run the Proc without a cursor.   CREATE MULTISET VOLATILE TABLE VT_COMP AS ( SELECT COMPANY_ID, COMPANY_NAME FROM COMPANY ...
5864321 Jul 2016 @ 01:41 PDTpradip_rangDatabaseTopicDefaulting during Teradata table loading through fast load Hello everyone, I am new to database and table loading, I am trying to load pipe separated .txt file into teradata table and i am using fast load mechanism. My requirement is that for few columns...

Pages