#DateForumTypeThreadPost
62131 Mar 2014 @ 01:42 PDTTrainingReplyNeed training in teradataMaddy, In addition, for online, training institutes , guidances, experiences etc related to Training, you can find  and also post under training forum : http://forums.teradata.com/forum/...
62031 Mar 2014 @ 12:27 PDTDatabaseReplyError handling when inserting records I am not Dieter, but just trying to help you, if it helps you. I hope you have already checked that you have insert privilege into error table.   See the select part alone first. ...
61930 Mar 2014 @ 11:55 PDTConnectivityReplyReading large table is slow Did you check with your DBA ??????? if he probably can check with dbschk,syscheck. How about your TD system like amps, nodes etc. It can also be due to bad table defination.It maybe due to prior...
61828 Mar 2014 @ 08:12 PDTAnalyticsReplyDependancies on DBC for Data ProcessingOther Databases that I know and work are using metadata  in conjunction with scripting ( say unix). Automation scripts to serve a business purpose are necessary. Product companies do not cover...
61728 Mar 2014 @ 10:39 PDTDatabaseReplySET table to Multiset TableI think you mean to say thus(example): Create multiset table dbname.multiset_table_name as dbname.set_tbl with data; It works. Why dont you try??
61628 Mar 2014 @ 03:35 PDTDatabaseReplyFinding User informationI am afraid if passwords can be obtained :). Did you select from  dbc.dbase?
61526 Mar 2014 @ 08:40 PDTDatabaseReplyHow to create auto generated ID in volatile table?Hi, From this link  http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1096_111A/Database.26.1905.html it shows that it cannot be done.  Pro...
61426 Mar 2014 @ 12:50 PDTDatabaseReplyhow to know the % table size growth/reduce in teradataIf you don't have a tool, then you can resort to using scripts(linux, perl, python etc) which will do computation.Then you can schedule your scripts as per your requirement using schedulers. S...
61325 Mar 2014 @ 11:41 PDTDatabaseReplyHow to create auto generated ID in volatile table?you can tweak a select query with row_number or you can create CREATE CREATE MULTISET VOLATILE TABLE tmp (       Field1 INTEGER GENERATED BY DEFAULT AS IDENTITY  &...
61225 Mar 2014 @ 01:48 PDTData ModelingReplyNovice seeking help for teradata EDW modellingTeradata is MPP architecture. Try to see its beauty employing your  business cases.Utilities like bteq,mload,tpump, fastload,fastexport, tpt are at hands.Initially,maybe you can try with emp...
61124 Mar 2014 @ 11:37 PDTDatabaseReplyerror when CALLing Teradata SP from C#Hi, Looks like the session settings issue: It reminds me of this link before: http://forums.teradata.com/forum/database/invalid-session-mode-for-procedure-execution Also, try to change in your ...
61024 Mar 2014 @ 05:02 PDTDatabaseReplyTeradata version detailsHi Sridhare, You can check the release notes too. Few links from outside that I make reference are like for older veriosn like 12 : http://www.docstoc.com/docs/16844876/Teradata-Databa...
60924 Mar 2014 @ 03:51 PDTDatabaseReplyFASTLOAD errorDid you check your input data? like if it has header.... You have not shared more information like your scripts. It may be that the data values witdh are  bigger than the defined column width...
60820 Mar 2014 @ 01:30 PDTDatabaseReplyTeradata New BieHi, You can see here: http://www.info.teradata.com/edownload.cfm?itemid=131540003 and there are more docs too. Cheers,
60719 Mar 2014 @ 03:59 PDTDatabaseReplyCalling Power Shell Script from within Bteq scriptCan you try with both OS and SYSTEM too like: .SYSTEM 'cmd /c F:\your_directory\...\abc.exe'; Try with just one command , maybe like copy abc file to another directory. Also try to run...
60618 Mar 2014 @ 06:13 PDTDatabaseReplyCDC CDC is change data capture. It is essential in DWH/BI project to see changed data.Different techniques are available like change in timestamps, versioning of rows, indicators, or both timestamps...
60514 Mar 2014 @ 06:18 PDTDatabaseReplyInsert not workingAre you allowed to use merge? ???? when matched then ..when not matched then ..... Have a look at the syntax. Cheers,
60413 Mar 2014 @ 03:43 PDTTeradata ApplicationsReplyFast Export for tables having more than 600 ColumnsTo prove that it is one row (or so-called one line), you can  grep that value or you can use head and tail unix commands together,,i mean pipe; Cheers,
60313 Mar 2014 @ 12:55 PDTDatabaseReplyHow is a Teradata SQL query parsed and executed?It is very long. I suggest you go through the link http://www.info.teradata.com/edownload.cfm?itemid=131540016 . As for oracle, you can check with their website as I am a bit outdated with t...
60212 Mar 2014 @ 10:58 PDTDatabaseReplyHelp needed with more specific prefix matching (closest match)There should be a fixed formulated logic to arrive at your required output. If not so, then a lot of formulated logics (permutation and combination can arise). How do you arrive at 1616, USA? Many...
60112 Mar 2014 @ 02:37 PDTDatabaseReplyThe Parcel Stream is InvalidHi, Do you update manually using Teradata and once done, you use ab initio for inserting? One reason can be the dbc file content is changed like  db name, username,password .. Did you tes...
60007 Mar 2014 @ 12:17 PSTDatabaseReplyfinding links between two col values..Will this be ok for you? select a.* from test_table1 a, test_table1 b where a.cola=b.colb  
59906 Mar 2014 @ 11:53 PSTDatabaseReplyUsing Teradata in OLTP application  I try this on oracle db and it shows 0.02 seconds. This is from emp table having only 14 rows. SELECT * FROM EMP WHERE DEPTNO IN(10,20,30,40) In oracle too, we find 0.00 seconds if we run...
59804 Mar 2014 @ 07:59 PSTDatabaseReplyPassing Macro Paramaters to a With ClauseI login to  bteq thru linux. I am in 14.10 and it works fine for me.  I executed  exec macro_test('1992-01-21'); Cheers,
59703 Mar 2014 @ 10:58 PSTGeneralReplyGet the Stored Procedure name currently executing---Avoiding hard coding of procedure , if there is a call of procedure inside another one ...... I dont know how the tracking is done Probably you may need more info too besides proc name.Will it ...

Pages