All forum activity

#DateUserForumTypeThreadPost
4485130 Sep 2014 @ 02:47 PDTfrnewbroughToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCThen you should be good then. You could possibly improve performance through elimination of the landing of the data. Below is a link you can look at which shows a TPT only example. I personally pre...
4485030 Sep 2014 @ 02:10 PDTDW4LifeToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCThe CDC process has been in place for sometime and we have done a POC which shows the proposed architcture working nicely. The concern really is whether there is another alternative methodology we ...
4484930 Sep 2014 @ 02:00 PDTjdliauTeradata ApplicationsReplyFastLoad process hang with concurrent sessions The concurrency is 5 but we observed the same issue even at 3. We are wonering if this only happens on "Windows 2012 R2" because we have another machine running "Windows Server 2008 ...
4484830 Sep 2014 @ 01:57 PDTfrnewbroughToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCSome questions: How long has the existing CDC process been in place? Is it home grown? Was Teradata engaged to tune or architect it? The reason I'm asking is I know of a client that uses a sim...
4484730 Sep 2014 @ 01:26 PDTfrnewbroughDatabaseReplyDynamic value for SAMPLE RANDOMIZED ALLOCATIONYou should look at this -> http://forums.teradata.com/forum/database/getting-a-dynamic-sample
4484630 Sep 2014 @ 01:23 PDTfrnewbroughDatabaseReplyDynamic value for SAMPLE RANDOMIZED ALLOCATIONI don't believe that is possible. I tried several options but no dice.
4484530 Sep 2014 @ 01:22 PDTfgrimmerTeradata StudioTopicWorkaround for Problem Occurred during Data Labs Smart LoaderIf you are getting a 'Problem Occurred Error: An internal error occurred during: "Load DataXXX"', resulting in a Null Pointer Exception when running Smart Loader via the Data Lab ...
4484430 Sep 2014 @ 12:25 PDTMatthew.VilleneuveDatabaseTopicDynamic value for SAMPLE RANDOMIZED ALLOCATIONI'm trying to input a dynamic value for SAMPLE RANDOMIZED ALLOCATION as in the example below. This produces an error: expected something like an integer or a decimal number... Is there any way...
4484330 Sep 2014 @ 12:23 PDTDW4LifeToolsTopicSeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCCurrently faced with an envionment that looks as such: Source: AS/400 Target: Teradata ETL Tool: Informatica   Requirement: Low Latency / Near Real Time Data Availability Problem: When p...
4484230 Sep 2014 @ 12:23 PDTfrnewbroughDatabaseReplyIDLE sessions IMPACTThe impact is very minor. That said if you would like to clean them up you can setup an alert in viewpoint to run a process to do so or could simply schedule a process to do the clean up regularly....
4484130 Sep 2014 @ 12:11 PDTfrnewbroughTeradata ApplicationsReplyFastLoad process hang with concurrent sessions How many concurrent processes are you running? What I'd do is run load tests with varying levels of concurrency to see how reliably I can reproduce the error and to see if lower levels of concu...
4484030 Sep 2014 @ 11:46 PDTtdradhaDatabaseTopicIDLE sessions IMPACTHi, Does anyone have idea about what IDLE session can impact on the System? One of my Application id loads the data /reads the data and after that most of the sessions are sitting in IDLE state.(...
4483930 Sep 2014 @ 11:19 PDTfrnewbroughDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Welcome. 
4483830 Sep 2014 @ 10:58 PDTbrcrissToolsReplyTPT OLE DB and TPT moving to version 15Anybody?
4483730 Sep 2014 @ 10:24 PDTsan28GeneralReplyExecuting insert statements stored in a table without stored procBut how do I form this string and execute it? Right now I have one insert statement  in one row like - ID              &n...
4483630 Sep 2014 @ 10:14 PDTSandeepyadavDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Thanks Fred :)
4483530 Sep 2014 @ 10:08 PDTSandeepyadavDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Thanks a lot Raja :)
4483430 Sep 2014 @ 10:05 PDTfrnewbroughGeneralReplyAPPENDING A DYNAMIC VALUE ON A TABLE IN INSERT STATEMENT IN STORED PROCEDUREYou need to use dynamic sql. Something like this: SET v_sql_stmt =  'INSERT INTO LOG_Table'|| 'PRODUCT_NAME' ||' SELECT 1,''Success'';' CALL DB...
4483330 Sep 2014 @ 09:58 PDTRaja_KTGeneralReplyExecuting insert statements stored in a table without stored procyou can use ....example: insert into abc values(1) ;insert into def values('def') ;insert into hgi values('ddd',1);
4483230 Sep 2014 @ 09:56 PDTfrnewbroughDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Actually  DBC.tvm has the same problem with RequestText being replaced with Alter statements. I explored this previously.      
4483130 Sep 2014 @ 09:51 PDTJimHuddConnectivityReplyPowerCenter Express ODBC connection to local VM Ok, I can't work out how to include pictures in these posts, so here's the ODBC connection string I'm trying: Provider=Teradata;DBCName=LocTD151;Database=dbc;Uid=dbc; Pwd=dbc; a...
4483030 Sep 2014 @ 09:50 PDTfrnewbroughDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .Raja_KT Thanks for the tip I've never used DBC.texttbl 
4482930 Sep 2014 @ 09:48 PDTJimHuddConnectivityTopicPowerCenter Express ODBC connection to local VMHi, I've installed PowerCenter Express and I'm trying to create a connection in the Adminstrator but I'm getting an error.  I'll try to attach the screen shots of the ODBC set ...
4482830 Sep 2014 @ 09:43 PDTfrnewbroughDatabaseReplyDBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .The request text field is like that and if you do an alter on the table then poof even if the full request text were there it would be gone. :-) The best option is what Boopathi15 sugges...
4482730 Sep 2014 @ 09:39 PDTsan28GeneralTopicExecuting insert statements stored in a table without stored procHi all, In teradata, I have a bunch of insert statements which I create and store  in my volatile table. I need  to execute these insert statements. Our office environment doesn'...

Pages