|12641||30 Jul 2009 @ 11:00 PDT||srk||Jobs||Topic||Seeking Teradata Developer - Full Time position @ Baltimore, MD||The Project is for a federal Client, so we require only Green Card holders and US CitizensSkills: Strong Teradata Experience, Informatica, ETLSenior level ETL developer and data warehouse technolog... |
|12640||30 Jul 2009 @ 10:51 PDT||visakhcr||Enterprise||Reply||to get datatypes of all column from table||Why don't you try SHOW TABLE table_name; It will give the entire table definition. |
|12639||30 Jul 2009 @ 10:04 PDT||rakeshreddy43||Tools||Topic||DB2 database to teradata||Hi,Can anyone help me in loading teradata tables with DB2 tables without using Informatica. Is there any way by using loaders or BTEQ's.Thanks,Rakesh |
|12638||30 Jul 2009 @ 10:01 PDT||rakeshreddy43||Tools||Topic||Flat files to Teradata tables||HiCan anyone send me the procedure for loading the data from flat files(VSAM, txt, csv etc) to teradata tables without using Informatica. thanks,Rakesh |
|12637||30 Jul 2009 @ 08:50 PDT||Random_Thought||Database||Reply||CPU usage of PE and RSG?||Dieter, looking at that table there are 50 or so columns for CPU utilised?
some of the views that look at PE or AMP usage only select and sum certain ones.
Do you know where to find informati... |
|12636||30 Jul 2009 @ 08:35 PDT||Rob_Armitage||Tools||Topic||Fastload not handling VARCHAR field in Linux?||I'm having problems running Fastload from a Linux client where there's a variable length field present.
I want to copy a selection of data from the production server to the test one, I've tried ... |
|12635||30 Jul 2009 @ 08:30 PDT||AndyFults||General||Reply||Handling Gaps in Date Ranges.||Dieter,
I am thinking that If I can just come up with the begin dates of the periods, I could do the math outside the recursive SQL to determine ranges.
|12634||30 Jul 2009 @ 08:02 PDT||dnoeth||Tools||Reply||MLOAD with secondary index||Based on the indexname i guess MLoad complains about a USI.
And yes, it is possible, you can do the drop within the laod script, too.
Just have a look at the MLoad manual.
|12633||30 Jul 2009 @ 07:22 PDT||shivatera||Tools||Reply||MLOAD with secondary index||Something to say? Add your comment here. |
|12632||30 Jul 2009 @ 05:39 PDT||Adeel Chaudhry||Enterprise||Reply||to get datatypes of all column from table||Usually it is good to try your best as well! :)Here is the link: http://www.info.teradata.com/Why don't you just do a "SELECT * FROM DBC.COLUMNS" and checkout the columns .... they are pretty self-... |
|12631||30 Jul 2009 @ 05:36 PDT||altruist||Enterprise||Reply||to get datatypes of all column from table||thanks!but still from column type i can know char/varchar if i want to know its length then?hey...could you please send me the link where i can get teradata manual? it would be gr8thanks |
|12630||30 Jul 2009 @ 05:22 PDT||shivatera||Tools||Reply||MLOAD with secondary index||MLOAD with secondary index |
|12629||30 Jul 2009 @ 05:22 PDT||shivatera||Tools||Topic||MLOAD with secondary index||Hi,
we have many tables with secondary indexes and while loading it's giving error. we have dropped the secondary indexes and loaded the data. Is it possible to include the below statement in MLOA... |
|12628||30 Jul 2009 @ 05:06 PDT||Adeel Chaudhry||Enterprise||Reply||to get datatypes of all column from table||SELECT TRIM(DatabaseName) AS "DatabaseName", TRIM(TableName) AS "TableName", TRIM(ColumnName) AS "ColumnName", ColumnType FROM DBC.COLUMNS WHERE TableName = 'TableName';For exact data-types and t... |
|12627||30 Jul 2009 @ 04:49 PDT||altruist||Enterprise||Topic||to get datatypes of all column from table||Hi,i want to get all columnnames from a table A & its respective datatype.i could get it columnnamefrom below querysel columnname from dbc.columnswhere tablename ='A'and databasename = 'dtbs'how c... |
|12626||30 Jul 2009 @ 01:22 PDT||Raja_KT||Enterprise||Reply||Difficulty Inserting records into Large table||Hi,Can you please share your master table ddl strcuture at least the defination part..You can mask your field definations ......Thanks and regards,Raja |
|12625||30 Jul 2009 @ 12:10 PDT||dnoeth||Database||Reply||Sample duration in DBQLSummaryTbl ||It's for all DBQL tables, but the probability that the summary cache will overflow is much lower due to less data.
|12624||29 Jul 2009 @ 09:16 PDT||monisiqbal||Database||Reply||Sample duration in DBQLSummaryTbl ||Thanks. The flush rate field can change the default value (1 to 3600 secs) but I think that we aren't sure about the exact time taken by the sample because if the cache fills in earlier than the fl... |
|12623||29 Jul 2009 @ 08:02 PDT||vhari||Connectivity||Reply||ODBC character set tranlation problem||If your session-character-set is UTF8, all the character data ODBC driver receiving from database will be in UTF8. Later, it depends on how your application is fetching that data from ODBC. - If ... |
|12622||29 Jul 2009 @ 04:53 PDT||ahmadghazal||Database||Reply||SELECT TOP N - odd behaviour (v2r6)||Seems like a bug if it is a simple select TOP from table. |
|12621||29 Jul 2009 @ 02:50 PDT||feinholz||Tools||Reply||TPT error code 29||Please send me your script. If you could generat the output from the job and send me that as well, that would be helpful.
From the command line:
tlogview -j -f "*" -g
and redirect the... |
|12620||29 Jul 2009 @ 02:34 PDT||AndyFults||General||Reply||Handling Gaps in Date Ranges.||The prototype BTEQ executes in three minutes and it does indeed include processing all the same data as is being processed by the related cursor in the SP.
We may need to combine a call to a ... |
|12619||29 Jul 2009 @ 01:51 PDT||Greyghost||Enterprise||Reply||Difficulty Inserting records into Large table||Hey Dieter,Just to give you an update....Changing the table to Multiset worked! Huge performance improvements. I was able to load 72 million rows in 10 minutes!Many thanks for helping me work thr... |
|12618||29 Jul 2009 @ 12:03 PDT||dnoeth||Database||Reply||CPU usage of PE and RSG?||You're looking for the VprType column in ResUsageSVpr:
Type of vproc. In non-Summary Mode, the
values can be “NODE,” “AMP,” “PE,” “GTW,”
“RSG,” or “VSS”. In Summary Mod... |
|12617||29 Jul 2009 @ 11:56 PDT||dnoeth||Database||Reply||Teradata 12 and Subqueries||In most cases a Scalar Subquery might be rewritten as a Left Outer Join.
But your query is even easier (untested):
SELECT component_location_id, component_type_code,