All forum activity

#DateUserForumTypeThreadPost
4461122 Sep 2014 @ 08:30 PDTRaja_KTDatabaseReplyTeradata as object databaseVery much!!!example: TPT is an object-oriented client application, many UDFs are written in C++, Java,Aster's SNAP framework is object-oriented ......and many more.....
4461022 Sep 2014 @ 08:03 PDTRaja_KTDatabaseReplySelecting all rows that have a unique columnCan you show sample records, what you have and what you want? That will be easier. From my standpoint, it looks like group by is what you resort to using it, since you need all records. Why VT does...
4460922 Sep 2014 @ 07:50 PDTRaja_KTDatabaseReplyAccess Right 'G' abbreviationI am not sure, it can be for Global and Persistent data(GLOP). 
4460822 Sep 2014 @ 06:57 PDTwicikDatabaseTopicTeradata as object databaseWelcome, Some database systems does have some object-relational features although they are rather relational databases. Does Teradata have some?    
4460722 Sep 2014 @ 06:50 PDTcalvinlknDatabaseReplyHow to backup single table using ABUSolved , table can be restored if using COPY command instead of RESTORE
4460622 Sep 2014 @ 06:49 PDTcalvinlknToolsReplyABU 14.10 table restoring errorTested and table can be restored if using COPY command instead of RESTORE
4460522 Sep 2014 @ 06:05 PDTcalvinlknDatabaseTopicHow to backup single table using ABUHi,  I have installed ABU14.10. -- To backup a table for testing by option "Backup Selected Objects" , tried to backup particular table for testing. Steps : 1. Select option ...
4460422 Sep 2014 @ 06:04 PDTfeinholzToolsReplyFacing TPT error while lading data from flat file to Teradata Not sure what "next day I reviewed and got the same problem" means. "Reviewing" does not mean "fixing".   This script has several issues. First, please remove...
4460322 Sep 2014 @ 05:20 PDTfeinholzToolsReplyGetting error on Fastload..."nvalid state for Load"Yes, once the error tables are dropped, the job must start from the beginning, meaning you must drop and recreate the target table.  
4460222 Sep 2014 @ 05:16 PDTfeinholzToolsReplyRestarting Fastload if we have error with the source data fileNo, if everything is done correctly, you are actually NOT supposed to drop the error tables in order to restart a job that was paused. Dropping the error tables (and the row in the restart log tabl...
4460122 Sep 2014 @ 05:01 PDTfeinholzToolsReplyTeradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.Whenever you upgrade to a new version of TTU, always go to the patch server and look for the latest patches (inevitably, by the time people get around to upgrading, new patches are available). In f...
4460022 Sep 2014 @ 04:57 PDTricha.prvrToolsReplyFacing TPT error while lading data from flat file to Teradata thanks. next day I again reviewed and I got the same problem
4459922 Sep 2014 @ 03:32 PDTSue73AnalyticsReplyTeradata OLAP functions in SQLHi Dieter, Can you please advise if there is a better way to write the query above without using two derived tables? Thanks for your help!! Sue
4459822 Sep 2014 @ 03:31 PDTvlisConnectivityTopicDataStage Teradata ParametersWe are upgrading from Teradata 12 to Teradata 14, and DataStage 7.5.2 to DataStage 9.1 Existing Teradata DataStage stages will not be converted.  The following parameters are used to read an...
4459722 Sep 2014 @ 02:54 PDTlecompgGeneralTopicINSERT works but inside a PROCEDURE doesn't Any Idea? I have an INSERT statement which is pretty complex, BUT it inserts data in 10 minutes on average consistentlly.  When I put the INSERT into a PROCEDURE 'wrapper' so I can call it, it n...
4459622 Sep 2014 @ 02:43 PDTgrybackDatabaseReplychecking I/O skewYou can check I/O skew in Viewpoint query portlets, Query Monitor for points in time and Query Spotlight over durations of time.
4459522 Sep 2014 @ 02:36 PDTbrimDatabaseTopicSelecting all rows that have a unique columnI have raw data coming into a table for an ETL job, so I'd like to keep all the records. I'm trying to select all the rows that basically have a unique ID. This can obviously be resolved b...
4459422 Sep 2014 @ 12:45 PDTMoutusiDatabaseTopicchecking I/O skewHow can we check I/O skewed processing for a query?
4459322 Sep 2014 @ 11:52 PDTnick2408DatabaseTopicAccess Right 'G' abbreviationHi I have noticed an AccessRight 'G' in one of the tables. May I know its abbreviation? I am unable to find the abbreviation anywhere else including the documentation.   Thanks
4459222 Sep 2014 @ 11:19 PDTSAPDatabaseReplyRows should be appended to a column in teradataSorry Raja ... I am using TD 14 using Teradata Studio Express 15 .  UDF is totally new to me . I looked into Info.teradata.com but i need more help in preparing a UDF for my scenario . Can u ...
4459122 Sep 2014 @ 10:36 PDTRaja_KTDatabaseReplyRows should be appended to a column in teradataWith recursive may take a lot of spool. You can think of udf for concatenation, or you can extend your list above :). you have not told me the version , you are using.
4459022 Sep 2014 @ 10:10 PDTSAPDatabaseReplyRows should be appended to a column in teradatabut i need a generic one which should accomodate even if n number of values and concatenate it into same column.. like below  Name  Desc Sibhi    good bad n n n n n n n n n n ...
4458922 Sep 2014 @ 09:00 PDTRaja_KTDatabaseReplyRows should be appended to a column in teradata Which version of TD you are in? Can you try something like this? select name1,max(case when rn=1 then desc1 else '' end) ||max(case when rn=2 then desc1 else '' end) from...
4458822 Sep 2014 @ 08:48 PDTricha_rupaTrainingReplyAny best Training Centres you guys know in Hyderabad??Anitha ,You are right ,I am also a victim of Manohar in the recent batch.Nothing he covered and simply closed the batch.He gave some conent ,for me it was very difficult to understand.On a whole ...
4458722 Sep 2014 @ 07:50 PDTSAPDatabaseReplyRows should be appended to a column in teradataThanks a lot raja !!! but i dont have access to execute function tdstats.udfconcat :( :(  Please help me somehow !!!! I hitting my head for past 2 hours !!!

Pages