|44851||30 Sep 2014 @ 02:47 PDT||frnewbrough||Tools||Reply||Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC||Then 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... |
|44850||30 Sep 2014 @ 02:10 PDT||DW4Life||Tools||Reply||Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC||The 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 ... |
|44849||30 Sep 2014 @ 02:00 PDT||jdliau||Teradata Applications||Reply||FastLoad 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 ... |
|44848||30 Sep 2014 @ 01:57 PDT||frnewbrough||Tools||Reply||Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC||Some 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... |
|44847||30 Sep 2014 @ 01:26 PDT||frnewbrough||Database||Reply||Dynamic value for SAMPLE RANDOMIZED ALLOCATION||You should look at this ->
|44846||30 Sep 2014 @ 01:23 PDT||frnewbrough||Database||Reply||Dynamic value for SAMPLE RANDOMIZED ALLOCATION||I don't believe that is possible. I tried several options but no dice.
|44845||30 Sep 2014 @ 01:22 PDT||fgrimmer||Teradata Studio||Topic||Workaround for Problem Occurred during Data Labs Smart Loader||If 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 ... |
|44844||30 Sep 2014 @ 12:25 PDT||Matthew.Villeneuve||Database||Topic||Dynamic value for SAMPLE RANDOMIZED ALLOCATION||I'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... |
|44843||30 Sep 2014 @ 12:23 PDT||DW4Life||Tools||Topic||Seeking Advice On Low Latency (Near Real Time) Loads using TPT and CDC||Currently faced with an envionment that looks as such:
ETL Tool: Informatica
Requirement: Low Latency / Near Real Time Data Availability
Problem: When p... |
|44842||30 Sep 2014 @ 12:23 PDT||frnewbrough||Database||Reply||IDLE sessions IMPACT||The 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.... |
|44841||30 Sep 2014 @ 12:11 PDT||frnewbrough||Teradata Applications||Reply||FastLoad 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... |
|44840||30 Sep 2014 @ 11:46 PDT||tdradha||Database||Topic||IDLE sessions IMPACT||Hi,
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.(... |
|44839||30 Sep 2014 @ 11:19 PDT||frnewbrough||Database||Reply||DBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .||Welcome.
|44838||30 Sep 2014 @ 10:58 PDT||brcriss||Tools||Reply||TPT OLE DB and TPT moving to version 15||Anybody?
|44837||30 Sep 2014 @ 10:24 PDT||san28||General||Reply||Executing insert statements stored in a table without stored proc||But how do I form this string and execute it? Right now I have one insert statement in one row like -
ID &n... |
|44836||30 Sep 2014 @ 10:14 PDT||Sandeepyadav||Database||Reply||DBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .||Thanks Fred :)
|44835||30 Sep 2014 @ 10:08 PDT||Sandeepyadav||Database||Reply||DBC.TABLES has truncated view defination in Requesttext field . How can i find full View defination .||Thanks a lot Raja :)
|44834||30 Sep 2014 @ 10:05 PDT||frnewbrough||General||Reply||APPENDING A DYNAMIC VALUE ON A TABLE IN INSERT STATEMENT IN STORED PROCEDURE||You need to use dynamic sql.
Something like this:
SET v_sql_stmt = 'INSERT INTO LOG_Table'|| 'PRODUCT_NAME' ||' SELECT 1,''Success'';'
CALL DB... |
|44833||30 Sep 2014 @ 09:58 PDT||Raja_KT||General||Reply||Executing insert statements stored in a table without stored proc||you can use ....example:
insert into abc values(1)
;insert into def values('def')
;insert into hgi values('ddd',1);
|44832||30 Sep 2014 @ 09:56 PDT||frnewbrough||Database||Reply||DBC.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.
|44831||30 Sep 2014 @ 09:51 PDT||JimHudd||Connectivity||Reply||PowerCenter 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:
|44830||30 Sep 2014 @ 09:50 PDT||frnewbrough||Database||Reply||DBC.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
|44829||30 Sep 2014 @ 09:48 PDT||JimHudd||Connectivity||Topic||PowerCenter Express ODBC connection to local VM||Hi, 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 ... |
|44828||30 Sep 2014 @ 09:43 PDT||frnewbrough||Database||Reply||DBC.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... |
|44827||30 Sep 2014 @ 09:39 PDT||san28||General||Topic||Executing insert statements stored in a table without stored proc||Hi 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'... |