All forum activity

#DateUserForumTypeThreadPost
1319810 Sep 2009 @ 11:38 PDTsk73DatabaseReplyView breaks on table changeHi newerakb,A view is like a virtual table. A view does not contain any data, but, its defintion is stored in the data dictionary. Also, VIEW columns are explicitly enumerated when a view is define...
1319710 Sep 2009 @ 11:19 PDTjohnhrschusterConnectivityTopicHelp or documentation for .net V12 or V13?We have downloaded the help file from Teradata and all of the links in it are blank. Does anyone have a valid HELP or documentation file for "Programming" not just installation for .net 12 or ...
1319610 Sep 2009 @ 10:58 PDTBBarkalowDatabaseReplyStored Procedures and the Data DictionaryDoes anyone have a suggestion on how to pursue an answer to this? I need to perform comprehensive searches across a large number of stored procedures and macros, and doing so one at a time through...
1319510 Sep 2009 @ 10:44 PDTJCoulterDatabaseTopicNeed replacement Teradata v2r6.1 install DLLI need to setup a demo environment and am using Teradata Warehouse Evaluation 8.1 CD, which contains Teradata Database v2r6.1.Unfortunately, the setup CD is scratched and one of the setup files is ...
1319410 Sep 2009 @ 09:16 PDTnewerakbDatabaseTopicView breaks on table changeIf you define a view to be "select * from tablename", shouldn't you be able to leave the view untouched if you ever change the column list in that table?Until now, every view at my work had been de...
1319310 Sep 2009 @ 08:55 PDTAnshDatabaseReplyAdding Compression to existing tableHi ,Alter does not support compression on existing tables.In such a case, there is no other option but to add a new column with compress attribute.Update all the values in old column to new column ...
1319210 Sep 2009 @ 06:33 PDTRaja_KTToolsReplyI am loading the data into files using fastexport but...Use mode record and format binary.
1319110 Sep 2009 @ 05:59 PDTprahladkDatabaseReplyAdding Compression to existing tableHi Ansh, Thanks for the reply. However this will work only when the table is empty. But I do not have that liberty.Is there any way where we can add more compression values to a table which contai...
1319010 Sep 2009 @ 05:33 PDTAnshDatabaseReplyAdding Compression to existing tableHi,You can use the ALTER command to add or modify the table columns and add compression information to it.For example :ALTER TABLENAME ADD columnname datatype compress (Values);
1318910 Sep 2009 @ 05:29 PDTJstaticThird Party SoftwareTopicComparison between Talend Integration Suite and Talend Open StudioHi all, I have been working with Talend Open Studio for a few weeks now and would like to have your opinion. Is using Talend Integration Suite really better compared to using Talend Open Studio? On...
1318810 Sep 2009 @ 02:20 PDTkiran_terydataToolsTopicI am loading the data into files using fastexport but...HiI am loading the data into files using fastexport but the data is in binary format eventhough i am using text format, please send me a sample script to load the data into tables in a text format....
1318710 Sep 2009 @ 02:06 PDTkiran_terydataToolsTopicI am unable to load data using SQL AssistanceHi FriendsI am unable to load the data when inserting nulls or strings in the table using QUERY MAN.insert into fact_current values(id, name, ,"expected",salary);Wat is the problem?Please tell me t...
1318610 Sep 2009 @ 12:58 PDTprahladkDatabaseTopicAdding Compression to existing tableHi, Has Teradata come up with a function to add compression values to the existing table columns' without dropping and recreating the table.Any update in this regard would be highly appreciated.re...
1318509 Sep 2009 @ 10:25 PDTanandagarwalToolsReplyhow to convert date format in MultiloadHi TD-ETL Developer, Approach mentioned is good, you have taken care for following d/m/yyyy dd/m/yyyy d/mm/yyyy mm/dd/yyyy also need to take care if year is coming as yy. data seems to...
1318409 Sep 2009 @ 03:39 PDTVadorToolsReplyVerify Version loadedfor BTEQ and F2ASTLOAD , invoke it and then enter the command :show versions;it gives you the information needed.other utilities might follow the same version
1318309 Sep 2009 @ 02:49 PDTGreyghostToolsTopicVerify Version loadedHow do I verify what version of software is loaded to our client? Here is what I need to verify: piom, tdicu, cliv2, teragss.I don't have the installation CD, and I need to validate the version.T...
1318209 Sep 2009 @ 07:51 PDTLewisDawsonViewpointReplyWidget developmentJian, Were you able to get the above example working?
1318108 Sep 2009 @ 05:18 PDTvhariConnectivityReplyODBC characters tarnslation issue- in your odbc.ini I do not see "Characterset" option, which represent the session's character-set. Since you did not specify anything, the default one is being used, which is ASCII. Suggest you ...
1318008 Sep 2009 @ 04:46 PDTBalamurugan BDatabaseReplyDesign IssueHi,To add more on choosing PI first do the data profiling:Consider both the column as candidate columns for PI selection and identify the following stats for each of them: 1. Number of rows 2...
1317908 Sep 2009 @ 08:53 PDTKksDatabaseTopicTeradata Version Upgrade to V2R12Hi All,We are currently on V2R6.2 , 64 bit SUSE and plan to upgrade to V2R12 Please share your experience with upgrade to V2R12 like how much time it took and what all precautions were taken or sen...
1317808 Sep 2009 @ 02:18 PDTMuruganMohanConnectivityTopicTrusted Connection in .Net data provider DriverHi, I a trying to connect to Teradata using Teradata.Client.Provider driver. When I provide user name and password it connects without any problem, but I want to connect to the database using my O...
1317708 Sep 2009 @ 02:16 PDTThiruDatabaseReplyInformatica sessions failing to connection TeradataAre you using the same user id for all the jobs? if so, then try to use different batch user id for respective jobs.
1317608 Sep 2009 @ 12:39 PDTayaz456DatabaseReplyLock InfoWe can also use Locking Modifier with NO WAIT Option to check if lock exists or not ?
1317507 Sep 2009 @ 11:08 PDTpraweenEnterpriseTopicCould any one help me in learning teradataHi friends, This is praveen. I heard about this software recently and I would like to learn this software. Could any one help me in learning this software. I would like to how to start. I am from...
1317407 Sep 2009 @ 08:54 PDTsk73DatabaseReplyhow to read data from excel file onto TeradataThanks jimm. this info helped me too.

Pages