#DateForumTypeThreadPost
9123 Jul 2015 @ 01:48 PDTViewpointTopicActual time & Actual Rows in Query MonitorA query with 25 steps shows actual time & rows only for the first 20 steps. The last 5 steps are always empty ie not filled though the query completes successfully. Is it a bug or feature?
9006 Jan 2012 @ 03:08 PSTToolsReplySQL Assistant: System.ArgumentOutOfRangeException Increase the "Maximum Response Buffer Size" value in SQL assistant properties to avoid this issue.
8919 Jul 2010 @ 05:09 PDTDatabaseReply<Error> value for a fieldDieter, In DEFINE the field is specified as CHAR and in the target table it has VARCHAR. As you have mentioned that the blanks would be trim, is there a work around for this issue without cha...
8819 Jul 2010 @ 03:14 PDTDatabaseTopic<Error> value for a fieldAll, The source data contains single or double blanks, which inturn are loaded into teradata using fastload script. In teradata the filed is a not null field. Once the fastload process completes...
8724 Mar 2009 @ 06:53 PDTDatabaseReplyUSI in multiloadUSI is a two amp operation. Multiload application phase is local amp process. For NUSI the subtable is present in the same amp of the actual record, whereas in USI the data and subtable may remain ...
8624 Mar 2009 @ 06:45 PDTToolsReplyHow to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility? To skip the first record you can use the keyword 'Record 2', which will start extracting from the 2nd record.I am not sure about skipping the last record.
8510 Mar 2009 @ 06:39 PDTToolsReplyGetting an error on xport commandFound that the error is thrown by Dispatcher :-(
8410 Mar 2009 @ 06:36 PDTToolsReplyGetting an error on xport commandJoed,I would like to know if the rowcount is taken from the actual execution of the query or from the Parser (Explain plan).I face the same issue when doing a cross join with two datasets having ju...
8303 Jan 2009 @ 03:42 PSTDatabaseReplyNon equi join conditionI agree to that.The problem lies in the second and third joins where non equi joins are used.Is there a way to break up this? Or an alternate way to implement this.FYI:-All three joins are inner jo...
8202 Jan 2009 @ 11:34 PSTDatabaseTopicNon equi join conditionOf 3 join conditions first is equi join, second is = join.First two conditions use primary index of left table. I would like to know if the primary index would be useful in this join (ie one colum...
8128 Nov 2008 @ 03:53 PSTDatabaseTopicWhat is the difference between roles and profiles?Could someone please explain the difference between roles and profiles?
8012 Aug 2008 @ 01:13 PDTToolsReplyfast load performanceWe are using informatica for this. Could you please give any performance pointsin that aspect?
7911 Aug 2008 @ 06:54 PDTToolsTopicfast load performanceLoading 350 million records from oracle to teradata takes around 15hrs using informatica fastload connection.Performance of this need to be increased. Could you please help me on this to reduce the...
7815 Jul 2008 @ 03:24 PDTDatabaseTopicCOALESCE performanceWhat would be the impact of using case statements instead of COALESCE fn?Clarify if COALESCE fn internally builds case statements to check for null. If yes will CASE statement perform better than C...
7715 Jul 2008 @ 03:12 PDTDatabaseTopicOrder of WHERE clause conditionsI am running a normal insert-select query on a huge teradata table to populate another teradata table. There are 3 filter conditions in the where clause of which 2 are date field filters and the ot...
7625 Jun 2008 @ 12:30 PDTDatabaseReplyCase inside caseIt's done by using AND clause with multiple WHEN(condition) in same CASE statement instead of cascade.
7523 Jun 2008 @ 03:49 PDTDatabaseTopicCase inside caseDoes teradata allow to use cascading case statements.Likesum(case when exp1 then Case when exp2 then EndElse EndIf yes will there be a performance issue? Each c...
7423 Jun 2008 @ 03:40 PDTToolsReplyOracle to teradata using informaticaThat was a good info...Thank you
7311 Jun 2008 @ 05:01 PDTToolsReplyOracle to teradata using informaticaCould someone pls respond to my above query?
7206 Jun 2008 @ 05:36 PDTToolsTopicOracle to teradata using informaticaMy requirement is to load huge volume of data from oracle to teradata without having a flat file in middle using informatica. The teradata table is an empty one. Could someone tell me if relational...
7121 May 2008 @ 02:15 PDTDatabaseReplyTranspose using Dynamic SQLThat is a valid answer.What if my expense id keeps changing, but I have a reference table which holds all the expense and I need to aggregate dynamically?
7019 May 2008 @ 01:25 PDTDatabaseTopicTranspose using Dynamic SQLMatrix is to be created using aggregate values of different Expenseid's for the employees. Matrix table Empl Exp1 Exp2 Exp3 Exp41 1000 2000 1200 23002 3212 1800 900 1850Source ...
6922 Apr 2008 @ 01:10 PDTToolsTopicInformatica Loader connectionDo informatica 7.1 have Teradata loader connection options? If yes when was it released?Any info on when was informatica 8.1.1 released?
6817 Apr 2008 @ 06:28 PDTUDAReplyOracle Informatica TeradataThe concept is the same, but the implementation process is different. You can do it in the way you have described using US n lookup's , also the way I have mentioned in the previous post. The SCD c...
6715 Apr 2008 @ 02:08 PDTUDAReplyOracle Informatica TeradataFor phase 1 you can either use informatica mapping using teradata loader connections (like fastload,tpump,multiload) or directly use teradata loader scripts to load data into staging table. Its pre...

Pages