323 | 13 Jun 2011 @ 02:51 PDT | Database | Reply | Supporting Multiple Environments on One Server | Hi,
Well, talk about ideal scenario .... yes every environment should be seperate .... starting from IP address, network cables, server etc etc etc!! But what if pocket doesn't allow that? :)
... |
322 | 13 Jun 2011 @ 02:39 PDT | Database | Reply | SQL help? | @Vamsi .... is the table historized? Just as D said .... more information can be helpful :) |
321 | 09 Dec 2010 @ 01:47 PST | Database | Reply | Implicit conversion CHAR to INT failing | Thanks Dieter! Needed exactly that kind of detail over why its happening. :)
Regards, MAC |
320 | 08 Dec 2010 @ 05:04 PST | Database | Topic | Implicit conversion CHAR to INT failing | Hi,
Have a following scenario:
Source table named TEST2:
CREATE SET TABLE Test2 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Col1... |
319 | 03 Sep 2010 @ 03:00 PDT | Extensibility | Reply | Data Migration from Oracle (Data Import) | Hi,
ETL tool can be a good option if possible in your case .... otherwise .... search for Data-Direct Connector and/or GoldenGate Data Connector .... they might also be used in your case.
Reg... |
318 | 03 Sep 2010 @ 02:54 PDT | Extensibility | Reply | Querying XML Data stored in the database | Hi,
You need to search for TeraXML or TeradataXML ... forgot the exact name my apologies for that!
Regards, MAC |
317 | 03 Sep 2010 @ 02:51 PDT | UDA | Reply | Drop Table "if exists" | The solution mentioned above can be easily implemented in Teradata and obviously can be called from SQL Assistant.
Regards, MAC |
316 | 03 Sep 2010 @ 02:48 PDT | Database | Reply | Soft RI | Hi,
As of restriction, it depends how you plan to implement it. For drawbacks, it include more effort and more CPU time for processing the same data-set. Nothing much I believe.
Regards, MAC |
315 | 03 Sep 2010 @ 02:41 PDT | Database | Reply | TIMESTAMP(0) showing .0 at the end | Hi,
This has to do with the FORMAT setting not at the database end, but at the application end. So try to tweak that. For assurance if the issue is same .... try to put data in file by casting i... |
314 | 03 Sep 2010 @ 02:38 PDT | General | Reply | Failure 2646 No more spool space in | Hi,
The user can have higher MaxPerm the DB/User it was created earlier .... there is no issue in that. Ideally what you should have done was to set values for the user and not for the DB.
Re... |
313 | 03 Sep 2010 @ 02:34 PDT | General | Reply | Teradata equivalent Query of SQL Server | Hi,
You can use the same query .... and replace ISNULL with COALESCE.
Regards, MAC |
312 | 05 Jul 2010 @ 01:58 PDT | Cloud Computing | Reply | Teradata Express for VMware Player - Growing Pains and Version Refresh | Hi,
Out of curiosity, do we have any download of 1TB version so far? :)
Regards,
MAC
|
311 | 05 Jul 2010 @ 01:56 PDT | Database | Reply | Day-to-Day DBA Task | Hi,
Though unlike other RDBMSs you won't find many of them .... but some can be space management across databases/users, DBQL tables periodic truncation (if enabled offcourse), refreshing statis... |
310 | 05 Jul 2010 @ 01:51 PDT | Database | Reply | External Table to load | Hi,
You can look into Table-UDFs for the similar functionality of external tables. Example can include Table-UDF over a text file, and then you can query it just as a normal table. Please note, ... |
309 | 29 Jun 2010 @ 11:21 PDT | Marketing & CRM | Reply | I need a MACRO that will allow the User to define the table | Elastic Marts Builder can be an option, thanks for sharing robpaller, but again .... k_suji86 .... if you could express the need more, it would be more useful. |
308 | 29 Jun 2010 @ 11:09 PDT | Database | Reply | About call Stored procedure in ASP | Hi,
Its been an age i worked on ASP .... but from what i can remember .... try looking into ADODB.Connection object and using that try to execute the command over that connection and use MOVENEX... |
307 | 29 Jun 2010 @ 11:02 PDT | Database | Reply | Identifying Status of CALL to Stored Proc? | Hi,
You can make use of stored-procedure labels to do this conditional exit with user-defined return-code.
Regards,
MAC |
306 | 29 Jun 2010 @ 10:59 PDT | Database | Reply | Collect Stats | Hi,
The time can be estimated over data-volume, data-type of column and count of columns. But off-course they can't be very accurate.
I believe, there isn't any way to do 'collect stale stats... |
305 | 29 Jun 2010 @ 10:47 PDT | General | Reply | BTEQ | Hi,
This can also be done using stored-procedure (SP) .... i.e. doing all the pre-processing of a variable in a SP, and returning that in the BTEQ.
Another option can be to do pre-processing ... |
304 | 23 Jun 2010 @ 11:30 PDT | UDA | Reply | Oracle Reports connectiing to TERADATA | @datawarehousing: Am sure you have been working with DWH for good 3 years, please don't flood the forum with similar messages no where near to a solution of a raised problem!
@CarlosAL: Nice lin... |
303 | 23 Jun 2010 @ 11:12 PDT | Database | Reply | The same user already logged on to DBS... | Hi,
Are you using same version of ARCMAIN for both activities?
Regards,
MAC |
302 | 23 Jun 2010 @ 11:10 PDT | Database | Reply | How to select values based on variable name and primary key using SQL | Hi,
What sort of data-volume is expected in this table?
Regards,
MAC |
301 | 22 Jun 2010 @ 09:30 PDT | Database | Reply | Regarding upsert | Hi,
Logically putting UPSERT in one line: If the row exists (same PK), it'll update, if not it'll insert.
Example is as follows:
MERGE INTO
Table1 AS tt
USING
Table1_tmp AS st
ON
... |
300 | 22 Jun 2010 @ 09:26 PDT | Third Party Software | Reply | Security Code vulnerabilities in Informatica seciprts, BTEQ Scripts | Hi,
Your statement is bit confusing .... Informatica mappings are being developed over BTEQ scripts? Or BTEQ scripts are being used in Informatica mappings?
Regards,
MAC |
299 | 22 Jun 2010 @ 09:16 PDT | Analytics | Reply | MAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504 | Hi,
What you are trying to do is to get two MAX() values, one partitioned other over whole data-set. As semantically it is wrong, so you need to re-valid what exactly you are trying to do here.
... |