All forum activity

#DateUserForumTypeThreadPost
1264130 Jul 2009 @ 11:00 PDTsrkJobsTopicSeeking Teradata Developer - Full Time position @ Baltimore, MDThe 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...
1264030 Jul 2009 @ 10:51 PDTvisakhcrEnterpriseReplyto get datatypes of all column from tableWhy don't you try SHOW TABLE table_name; It will give the entire table definition.
1263930 Jul 2009 @ 10:04 PDTrakeshreddy43ToolsTopicDB2 database to teradataHi,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
1263830 Jul 2009 @ 10:01 PDTrakeshreddy43ToolsTopicFlat files to Teradata tablesHiCan anyone send me the procedure for loading the data from flat files(VSAM, txt, csv etc) to teradata tables without using Informatica. thanks,Rakesh
1263730 Jul 2009 @ 08:50 PDTRandom_ThoughtDatabaseReplyCPU 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...
1263630 Jul 2009 @ 08:35 PDTRob_ArmitageToolsTopicFastload 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 ...
1263530 Jul 2009 @ 08:30 PDTAndyFultsGeneralReplyHandling 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.
1263430 Jul 2009 @ 08:02 PDTdnoethToolsReplyMLOAD with secondary indexBased 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. Dieter
1263330 Jul 2009 @ 07:22 PDTshivateraToolsReplyMLOAD with secondary indexSomething to say? Add your comment here.
1263230 Jul 2009 @ 05:39 PDTAdeel ChaudhryEnterpriseReplyto get datatypes of all column from tableUsually 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-...
1263130 Jul 2009 @ 05:36 PDTaltruistEnterpriseReplyto get datatypes of all column from tablethanks!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
1263030 Jul 2009 @ 05:22 PDTshivateraToolsReplyMLOAD with secondary indexMLOAD with secondary index
1262930 Jul 2009 @ 05:22 PDTshivateraToolsTopicMLOAD with secondary indexHi, 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...
1262830 Jul 2009 @ 05:06 PDTAdeel ChaudhryEnterpriseReplyto get datatypes of all column from tableSELECT 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...
1262730 Jul 2009 @ 04:49 PDTaltruistEnterpriseTopicto get datatypes of all column from tableHi,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...
1262630 Jul 2009 @ 01:22 PDTRaja_KTEnterpriseReplyDifficulty Inserting records into Large tableHi,Can you please share your master table ddl strcuture at least the defination part..You can mask your field definations ......Thanks and regards,Raja
1262530 Jul 2009 @ 12:10 PDTdnoethDatabaseReplySample 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. Dieter
1262429 Jul 2009 @ 09:16 PDTmonisiqbalDatabaseReplySample 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...
1262329 Jul 2009 @ 08:02 PDTvhariConnectivityReplyODBC character set tranlation problemIf 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 ...
1262229 Jul 2009 @ 04:53 PDTahmadghazalDatabaseReplySELECT TOP N - odd behaviour (v2r6)Seems like a bug if it is a simple select TOP from table.
1262129 Jul 2009 @ 02:50 PDTfeinholzToolsReplyTPT error code 29Please 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...
1262029 Jul 2009 @ 02:34 PDTAndyFultsGeneralReplyHandling 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 ...
1261929 Jul 2009 @ 01:51 PDTGreyghostEnterpriseReplyDifficulty Inserting records into Large tableHey 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...
1261829 Jul 2009 @ 12:03 PDTdnoethDatabaseReplyCPU 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...
1261729 Jul 2009 @ 11:56 PDTdnoethDatabaseReplyTeradata 12 and SubqueriesIn 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, AXLE, SIDE, TRUCK ...

Pages