#DateForumTypeThreadPost
74623 Jun 2014 @ 11:18 PDTToolsReplyFastload exit code verificationUsually, it is checked in unix/linux at the end ..something like this sample after logging off: CR=$?   if [ $CR -ne 0 ] then      echo " failed" ...
74523 Jun 2014 @ 05:46 PDTDatabaseReplyThe Parcel Stream is InvalidMaybe you can contact the support team from the vendor. For Abinitio, you can send the package to support at abinitio. You can get the email address from the console. They will analyse it and send ...
74422 Jun 2014 @ 11:28 PDTGeneralReplywithout specifying CASE SPECIFIC in a table, How can we retrieve only lower case letters in teradataCTry setting to ANSI mode; .set session transaction=ANSI  
74322 Jun 2014 @ 10:57 PDTToolsReplyHandling timestamp column during fast exportJust the initial thought.How about your sessions? how many!!! Is it peak time?  You can think of fastexport too. 
74222 Jun 2014 @ 05:45 PDTJobsReplyWhich all skills needed along with Teradata for growth in DWH field Teradata itself is an ocean. Teradata has utilities replete with special features such as columnar and temporal besides common features of DBs ..., appliances...., AEDW, Aster( MR,GR, DB),Viewpo...
74121 Jun 2014 @ 12:30 PDTGeneralReplyI have defined PPI on a table.But i am not using PPI in a Where clause,how would be the performance You can run the explain and see it.   Partitioning is done to avoid full table scan.Performance is achieved when a restrictive condition on the partitioning column is placed.If you ...
74021 Jun 2014 @ 12:25 PDTGeneralReplyI have defined PPI on a table,if i use PI in where clause,whether it go and search each and every partition or single partitionYou have not shared your DDL, so that it will be specific. You can see it using explain. The best one to explain is the Optimzer :) You can have a look at this post. It may be of your interest.It...
73920 Jun 2014 @ 11:48 PDTDatabaseReplyAdding Values across multiple columnsMaybe you can think of writing in Javascript itself since it is html. There you have lots of options: functions, branching, looping etc... You have the logic at hands.  
73819 Jun 2014 @ 09:29 PDTGeneralReplyhow to eliminate duplicate records in a file while loading into the target table without using fastloadDo you want to use unix/linux command? something like this sort ... filename|uniq..... or use awk. You can see the arguement here :) http://forums.teradata.com/forum/analytics/why-uv-in-mload ...
73719 Jun 2014 @ 09:06 PDTGeneralReplyHOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQBT ;SEL DATE ;ET; =5 OR use unix loops  
73619 Jun 2014 @ 08:49 PDTDatabaseReplyCreating a query to Teradata using linux bash scriptingI am not pretty much aware of your Sitescope server. I do not know if ssh authentication and execution can be done remotely, from  another server. Maybe you can see if the feature of remote co...
73518 Jun 2014 @ 11:10 PDTDatabaseReplyCreating a query to Teradata using linux bash scripting From bteq ref document. You can modify or customize  as per your requirement. This line usually is #!/bin/bash as per Linux installer. You can validate if bash is set thus.   ...
73418 Jun 2014 @ 10:26 PDTTeradata ApplicationsReplyConverting TimeStamp into DateTo avoid casting- for now I can think of is to make both the joining fields consistently the same format in ddl, if a frequent join and query. 
73318 Jun 2014 @ 10:18 PDTTeradata ApplicationsReplyHow to Pass mutliple values from text file to parametrized bteq Very much you can do that. You can assign the entire thing to a variable and use that as parameter. For ease of testing, use echo and see the output, whether it conforms to SQL syntax properly or n...
73218 Jun 2014 @ 08:46 PDTDatabaseReplyRemove Unsuded StatsI am not sure if you are looking for "ValidStats" field  in our great man blog ( I mean Dieter's). http://developer.teradata.com/blog/dnoeth/2013/08/new-statsinfo-query-for-td14
73118 Jun 2014 @ 08:40 PDTTeradata ApplicationsReplyHow to Pass mutliple values from text file to parametrized bteq If I understand you correctly. You can think of a unix script, running a loop(for,while,do while). Inside a loop, do a readline. Extract or cut  the first field start_date delimited...
73017 Jun 2014 @ 07:21 PDTData ModelingReplyDatabase Design Tool Besides Erwin, I see Sybase's PowerDesigner is good but again you want a cheap/free one hmmm. I am sure, you have to compromise a lot on the features if you want free. To be honest I...
72915 Jun 2014 @ 01:46 PDTDatabaseReplyTeradata FunctionsHi Sasha, Whaw!!!! All I can think of now is providing the links for you to see and code. You can download the docs. http://www.info.teradata.com/edownload.cfm?itemid=140900023  http://www....
72815 Jun 2014 @ 12:48 PDTDatabaseReplyNew Stats Collection Process in Teradata 14.10Hi Kishore, Hope this link can help you.  In Teradata 13.10, this piece was  there. So helping to identify objects for drop is same: Recommended for drop ...
72713 Jun 2014 @ 07:20 PDTGeneralReplywhat might be the reason if a job fails in acqusition phase and application phase   For mload, you can read the this small chapter "Handling Teradata MultiLoad Errors". It  explains about Acquisition Error Table and Application Error Table. Reading the...
72613 Jun 2014 @ 06:43 PDTDatabaseReplyFinding the difference between two records in a table.Hope this helps, example: SELECT * FROM(    SELECT 'FROM_A' as A1, A.ID, A.COL1, A.COL2, A.COL3, ...   FROM from tab   UNION ALL   SELECT &...
72512 Jun 2014 @ 11:32 PDTToolsReplyBTEQ - Executing commands after .run file statementHow about .EXPORT RESET? Is there anything extra in logon.txt????????
72412 Jun 2014 @ 11:01 PDTToolsReplyBTEQ - Executing commands after .run file statement I think this is what you are looking for. In bteq you can execute os commands, using .os    example: .if errorcode = 0 then .os echo  '.goto abcdefg' > ...
72312 Jun 2014 @ 09:19 PDTDatabaseReplyIndex and stats on volatile table From "SQL Request and Transaction Processing" document, page 210   Teradata Database automatically collects session-level derived statistics for materialized global te...
72212 Jun 2014 @ 08:16 PDTDatabaseReplyDiretct User Login Vs. Query banding.Hi Srini, I do not have a comparison sheet. Let us see if anyone replies. Cheers,

Pages