|44611||22 Sep 2014 @ 08:30 PDT||Raja_KT||Database||Reply||Teradata as object database||Very 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.....
|44610||22 Sep 2014 @ 08:03 PDT||Raja_KT||Database||Reply||Selecting all rows that have a unique column||Can 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... |
|44609||22 Sep 2014 @ 07:50 PDT||Raja_KT||Database||Reply||Access Right 'G' abbreviation||I am not sure, it can be for Global and Persistent data(GLOP).
|44608||22 Sep 2014 @ 06:57 PDT||wicik||Database||Topic||Teradata as object database||Welcome,
Some database systems does have some object-relational features although they are rather relational databases.
Does Teradata have some?
|44607||22 Sep 2014 @ 06:50 PDT||calvinlkn||Database||Reply||How to backup single table using ABU||Solved , table can be restored if using COPY command instead of RESTORE
|44606||22 Sep 2014 @ 06:49 PDT||calvinlkn||Tools||Reply||ABU 14.10 table restoring error||Tested and table can be restored if using COPY command instead of RESTORE
|44605||22 Sep 2014 @ 06:05 PDT||calvinlkn||Database||Topic||How to backup single table using ABU||Hi,
I have installed ABU14.10.
-- To backup a table for testing by option "Backup Selected Objects" , tried to backup particular table for testing.
1. Select option ... |
|44604||22 Sep 2014 @ 06:04 PDT||feinholz||Tools||Reply||Facing 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... |
|44603||22 Sep 2014 @ 05:20 PDT||feinholz||Tools||Reply||Getting 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.
|44602||22 Sep 2014 @ 05:16 PDT||feinholz||Tools||Reply||Restarting Fastload if we have error with the source data file||No, 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... |
|44601||22 Sep 2014 @ 05:01 PDT||feinholz||Tools||Reply||Teradata 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... |
|44600||22 Sep 2014 @ 04:57 PDT||richa.prvr||Tools||Reply||Facing TPT error while lading data from flat file to Teradata ||thanks. next day I again reviewed and I got the same problem
|44599||22 Sep 2014 @ 03:32 PDT||Sue73||Analytics||Reply||Teradata OLAP functions in SQL||Hi 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!!
|44598||22 Sep 2014 @ 03:31 PDT||vlis||Connectivity||Topic||DataStage Teradata Parameters||We 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... |
|44597||22 Sep 2014 @ 02:54 PDT||lecompg||General||Topic||INSERT 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... |
|44596||22 Sep 2014 @ 02:43 PDT||gryback||Database||Reply||checking I/O skew||You can check I/O skew in Viewpoint query portlets, Query Monitor for points in time and Query Spotlight over durations of time.
|44595||22 Sep 2014 @ 02:36 PDT||brim||Database||Topic||Selecting all rows that have a unique column||I 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... |
|44594||22 Sep 2014 @ 12:45 PDT||Moutusi||Database||Topic||checking I/O skew||How can we check I/O skewed processing for a query?
|44593||22 Sep 2014 @ 11:52 PDT||nick2408||Database||Topic||Access Right 'G' abbreviation||Hi
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.
|44592||22 Sep 2014 @ 11:19 PDT||SAP||Database||Reply||Rows should be appended to a column in teradata||Sorry 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 ... |
|44591||22 Sep 2014 @ 10:36 PDT||Raja_KT||Database||Reply||Rows should be appended to a column in teradata||With 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.
|44590||22 Sep 2014 @ 10:10 PDT||SAP||Database||Reply||Rows should be appended to a column in teradata||but i need a generic one which should accomodate even if n number of values and concatenate it into same column.. like below
Sibhi good bad n n n n n n n n n n ... |
|44589||22 Sep 2014 @ 09:00 PDT||Raja_KT||Database||Reply||Rows 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... |
|44588||22 Sep 2014 @ 08:48 PDT||richa_rupa||Training||Reply||Any 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 ... |
|44587||22 Sep 2014 @ 07:50 PDT||SAP||Database||Reply||Rows should be appended to a column in teradata||Thanks 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 !!!