#DateForumTypeThreadPost
59602 Mar 2014 @ 09:44 PSTGeneralReplySamples database and create databaseHi Sandeep, I log with dbc username/pwd . There are few databases like retail etc and tables like itemppi etc. You can use -select tablename from dbc.tables where databasename='retail' sa...
59527 Feb 2014 @ 08:09 PSTData ModelingReplySurrogate vs business keys It is a big topic :). It is driven by structure from sources and requirements.There are modelers who are for and against its use :).I can see for example, in cases , where we see heteregenous so...
59427 Feb 2014 @ 12:15 PSTDatabaseReplyChange One Row Data To Multiple Rows.In the older version, you can try  use union all of select statements by  use of substring delimited by ## for the second field- column1. Get the name and first substring of 200 and then ...
59326 Feb 2014 @ 01:28 PSTGeneralReplyMigrate Oracle UDF to Teradata UDFI think you have written a function in Oracle like create or replace function abc.def(....) .... where you can call in your dml say. If so, you can write a UDF. There are lots of materials on U...
59225 Feb 2014 @ 05:44 PSTGeneralReplyTDE 14.10.00.02 SLES 11 for VMwareIt works fine with me. You can refer to this link  if it helps you. I removed twice and re-installed :) http://forums.teradata.com/forum/cloud-computing/vmware-and-td-14-10 Cheers,
59123 Feb 2014 @ 07:48 PSTToolsReplyfastload on linux Ok :). If you can share your ideas on how you find a work-around for this :). I don't know how complex it is, since I never encountered this situation. Can't the data be vi-ed and edited? ...
59021 Feb 2014 @ 09:43 PSTToolsReplyfastload on linux It should be as Dieter said. I am not sure if od utility  works in Unix (to compare the files). In linux it works, just to confirm.
58921 Feb 2014 @ 09:25 PSTDatabaseReplyMultiple values using case statementTry this: .ACCEPT city,zip_code FROM parameter_file; .begin .... .export ...... select ..... from abc  where abc.city_name='&city' and abc.zip_cd='&...
58820 Feb 2014 @ 08:19 PSTToolsReplyfastload on linux It is strange. Usually unix and linux work well in tandem :). I am just curious if you make any change manually while moving from unix to linux....or  is it just ftpied or secured copy ... ?
58720 Feb 2014 @ 07:58 PSTGeneralReplyFYP ideasYou are finalizing in few days oops!!! you may need to think about the time you are going to devote to this project( usually for FYP). Is it that you have to take care of this or that you have to t...
58620 Feb 2014 @ 07:40 PSTTrainingReplyany good training istitue to learn teradataWhich place and which mode :) ???  Under training forum, you will see lots of advices and suggestions. There are many places but be aware of promises, infrastructure and know what you want.&...
58520 Feb 2014 @ 07:38 PSTTrainingReplyTERADATAYou could have placed under http://forums.teradata.com/forum/training/ :). Under training forum, you will see lots of advices and suggestions. There are places but be aware of promises, infra...
58420 Feb 2014 @ 08:22 PSTGeneralReplyFYP ideasI suggest you take up cases where you can  really justify questions like why you are using Teradata . People can corner you with questions from any angle. DWH is data warehousing. So choose go...
58320 Feb 2014 @ 07:57 PSTData ModelingReplyERwin vs PowerDesigner I have used both. Erwin in development but Powerdesigner a read-only for mapping :), but small projects. To be honest, you can see I have limited knowledge on the vast oceans of both these. ...
58220 Feb 2014 @ 07:06 PSTThird Party SoftwareReplyDWH/BI Project Analysis, Estimation,resource tool Yes agreed. For sure, I know it won't fit into all project reqts :). However, if it fetches  a good amount of information and results for projection, then it saves  a lot. So on the ...
58117 Feb 2014 @ 04:48 PSTDatabaseReplyWant to check if two specific columns exist in more than one tableHi Sri, How about  say: select databasename,tablename,columnname from dbc.columns where databasename in('dbc','retail'.....) and columnname in('your column here'.......
58016 Feb 2014 @ 02:33 PSTDatabaseReplyOnline backup performanceThink about the resources :) and priorities during online backups and regular. For regular one priority is given. In almost all DBs that I know Online backups are slower than regular . Cheers,
57913 Feb 2014 @ 08:56 PSTGeneralReplyPipe delimited fast export fileHi, You can do it.However, I see that many experts here have recommended using tpt. This link can help you> http://forums.teradata.com/forum/database/mode-and-format-td-utilities. Cheers,
57812 Feb 2014 @ 11:20 PSTGeneralReplycheck session history Do you have TD Viewpoint? Also you can try   select * from DBC.SessionTbl   select * from table(MonitorSession(1,'*',0)) as dt select * from dbc.logonoffv ...
57712 Feb 2014 @ 10:46 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?My thought on this: It is purely driven by business reqt. Creating and dropping of tables maybe because of statistics collection and changes of data demography etc. If it is necessary to leave an e...
57612 Feb 2014 @ 09:05 PSTDatabaseReplyteradataimporttool charset problemI am also curious for these characters that if we can change from DATABASE=test,CHARSET=UTF8 to DATABASE=test,CHARSET=UTF16. If it works .
57512 Feb 2014 @ 08:22 PSTDatabaseReplyRemoving duplicate records from teradata tableHi Ramkumar, There are umpteen suggestions available here :). ---[group by  and having or olap qualify way] http://forums.teradata.com/forum/database/delete-duplicate-rows-from-table-in-tera...
57412 Feb 2014 @ 02:33 PSTDatabaseReplyHOw do you ALTER table add partitions on a multilevel partitioned table?example : say.... SELECT * FROM yourtablexyz WHERE yourtablexyz.PARTITION#L2 = 1;   Cheers,
57311 Feb 2014 @ 07:06 PSTGeneralReplyparametrics queryYou can parameterize with many stuffs in unix or linux like below (say ksh file): export DB_NAME=dd01 export DB_USER_NAME=BATCH_1   DB_PASSWORD=xyz export LOG_FILENAME=$HOM...
57211 Feb 2014 @ 07:03 PSTTeradata ApplicationsReplyRun an teredata query on linuxYou need a client. Do you have knowledge on linux or unix scripting? (In linux or unix , more programming flexibilities and fun :) ) from any directory , you can run this  and see if bteq sa...

Pages