91 | 23 Jul 2015 @ 01:48 PDT | Viewpoint | Topic | Actual time & Actual Rows in Query Monitor | A 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?
|
90 | 06 Jan 2012 @ 03:08 PST | Tools | Reply | SQL Assistant: System.ArgumentOutOfRangeException |
Increase the "Maximum Response Buffer Size" value in SQL assistant properties to avoid this issue.
|
89 | 19 Jul 2010 @ 05:09 PDT | Database | Reply | <Error> value for a field | Dieter,
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... |
88 | 19 Jul 2010 @ 03:14 PDT | Database | Topic | <Error> value for a field | All,
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... |
87 | 24 Mar 2009 @ 06:53 PDT | Database | Reply | USI in multiload | USI 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 ... |
86 | 24 Mar 2009 @ 06:45 PDT | Tools | Reply | How 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. |
85 | 10 Mar 2009 @ 06:39 PDT | Tools | Reply | Getting an error on xport command | Found that the error is thrown by Dispatcher :-( |
84 | 10 Mar 2009 @ 06:36 PDT | Tools | Reply | Getting an error on xport command | Joed,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... |
83 | 03 Jan 2009 @ 03:42 PST | Database | Reply | Non equi join condition | I 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... |
82 | 02 Jan 2009 @ 11:34 PST | Database | Topic | Non equi join condition | Of 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... |
81 | 28 Nov 2008 @ 03:53 PST | Database | Topic | What is the difference between roles and profiles? | Could someone please explain the difference between roles and profiles? |
80 | 12 Aug 2008 @ 01:13 PDT | Tools | Reply | fast load performance | We are using informatica for this. Could you please give any performance pointsin that aspect? |
79 | 11 Aug 2008 @ 06:54 PDT | Tools | Topic | fast load performance | Loading 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... |
78 | 15 Jul 2008 @ 03:24 PDT | Database | Topic | COALESCE performance | What 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... |
77 | 15 Jul 2008 @ 03:12 PDT | Database | Topic | Order of WHERE clause conditions | I 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... |
76 | 25 Jun 2008 @ 12:30 PDT | Database | Reply | Case inside case | It's done by using AND clause with multiple WHEN(condition) in same CASE statement instead of cascade. |
75 | 23 Jun 2008 @ 03:49 PDT | Database | Topic | Case inside case | Does 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... |
74 | 23 Jun 2008 @ 03:40 PDT | Tools | Reply | Oracle to teradata using informatica | That was a good info...Thank you |
73 | 11 Jun 2008 @ 05:01 PDT | Tools | Reply | Oracle to teradata using informatica | Could someone pls respond to my above query? |
72 | 06 Jun 2008 @ 05:36 PDT | Tools | Topic | Oracle to teradata using informatica | My 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... |
71 | 21 May 2008 @ 02:15 PDT | Database | Reply | Transpose using Dynamic SQL | That 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? |
70 | 19 May 2008 @ 01:25 PDT | Database | Topic | Transpose using Dynamic SQL | Matrix 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 ... |
69 | 22 Apr 2008 @ 01:10 PDT | Tools | Topic | Informatica Loader connection | Do informatica 7.1 have Teradata loader connection options? If yes when was it released?Any info on when was informatica 8.1.1 released? |
68 | 17 Apr 2008 @ 06:28 PDT | UDA | Reply | Oracle Informatica Teradata | The 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... |
67 | 15 Apr 2008 @ 02:08 PDT | UDA | Reply | Oracle Informatica Teradata | For 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... |