#DateForumTypeThreadPost
1425 Feb 2010 @ 06:29 PSTToolsTopicTest teradata database statusHi AllI have requriment to test a database is up or down. I selected BTEQ to do my testing and below is my logic. As bteq is continously trying to logon, my script is running continously with out ...
1328 Aug 2008 @ 11:01 PDTDatabaseReplyPlease help with Drop Database problemexcellent.. its working and database gone....
1224 Jun 2008 @ 05:05 PDTToolsTopicCapturing the return code of bteq in shell variableCan any once please tell me how can i capture the return code retured by bteq script in shell?Thanks in advancePaddu
1113 Jun 2008 @ 03:12 PDTToolsReplyMLOAD script error.Yes.. thanks for your reply. It works.Now i am getting another error. I have changed every thing to varchar. but in source file i have data, time and timestamp values similary corresponding data,fl...
1013 Jun 2008 @ 02:13 PDTToolsTopicMLOAD script error.Hi Everyone when i am running following mload script using the '|' delimited source file, i am getting error as10:23:04 UTY1419 The field type for field PART is not allowed when using the VARTEXT ...
929 Dec 2007 @ 06:35 PSTDatabaseTopicTeradata database version command.Hi gurusCan any one tell me the command to find the version of the database.Thanks in advanceHarinath
820 Nov 2007 @ 07:01 PSTUDAReplyDifference and concepts of ETL.Hi AnilThird party ETL tools like Informatica or any other, will not change the performance behaviour. It only makes the Developer to interact with the databases with graphically and makes it as Us...
706 Oct 2007 @ 12:37 PDTUDAReplyChange in Primary Key on EDW tableThere are 2 ways to perform this.Present condition:1)you have a table with rows.2) Created a new column which will be the primary key.3) This new column have NULL in the existing records.If above c...
605 Oct 2007 @ 12:08 PDTUDAReplyDifference and concepts of ETL.HeyI dont know the cost of the tool or Licence, even i am working in Informatica i dont have these details.Coming to the importance, you are right, even so many are using Utilites of TD only. But t...
504 Oct 2007 @ 06:28 PDTUDAReplyDifference and concepts of ETL.Hi SubhaYes, what you told is exactly right. After looking into your comment, I made again my questions to my senior people. Now i was good enough.You have explanied about the FLOAD, let me add som...
404 Oct 2007 @ 09:18 PDTUDAReplyDifference and concepts of ETL.Its good and great explanation from all.Thanks a lot.... :-) In the mean while, i met so many experienced guys to have more on TD. Following are the points that i came to conclude on ETL of Teradat...
303 Oct 2007 @ 12:18 PDTUDAReplyDifference and concepts of ETL.Hey TenaYour thought on Informatica is Right.To overcome the PL/SQL codes, informatica helps a lot.I have some questions on your reply:1) Is PL/SQL present in Teradata?2) "Operation Databases" mean...
203 Oct 2007 @ 12:37 PDTUDAReplyDifference and concepts of ETL.Hi SupremeThanks for your guidelines....I have small doubt on it, you told that utilites are there(FLOAD\MLOAD\etc) to load data from Source systems to Target(Teradata database). Then why informati...
101 Oct 2007 @ 04:22 PDTUDATopicDifference and concepts of ETL.Hi Recently i was joined in IT Company. Now i am a Trainee in DWH, still no project are alloted to me.Last day my PM told that get trained in Teradata of ETL part, and didn't explain me any more.CA...