Search results for query: *

We are considering an Oracle 10g RAC configuration for a data warehouse. In order to determine the appropriate size, I need to know the amount of admin and temp space to reserve as system resources. For example in a 10 terabyte data warehouse, RAID 1 would take 5 TB, how much space would...

First I want to inform you that I am the Warehouse Administrator and not the BOEXI Administrator. There are some anomolies when running reports against Teradata through ODBC and I would like to have your insite. When running a report using a web browser and BOEXI as the server, it will open a...

We have multiple applications that we use to access TD through ODBC. Whenever a left outer join is created the qualifier on the right table is coded in the WHERE clause instead of the ON clause, in effect creating an inner join. Is this a function of the Application's interpretation of the...

I am new to CR and have Version 10 on my desktop. I am trying to work with an MS Analysis Services OLAP Cube. I can attach to the cube and create a report using the OLAP Wizard. I would like to use the OLAP Worksheet feature, but I do not have the "View Cube" selection from the preview grid...

Please excuse the length of this question. We are having a multitude of problems installing AS. When I first tried to use it I got the "Unable to get list of data mining algorthiums..." and as recommended we installed service pack 3a. Now it appears that somehow AS is associated with the...

We are looking at copying about 30 tables monthly between two SS 2000 instances. As a rule of thumb which would be most efficient, a snapshot backup/restore of the source tables or a snapshot replication? What would be some primary considerations in selecting a method?

This is not specific to Teradata, but I have found very knowledgable in these forums. I have been informed by our network team that the WAN between our Teradata Unix servers and our client site is 100mb full duplex ethernet. We have a switch in front of the servers that has a 10/100mb...

We have an "internal" session with a read lock on a table and can't figure out how to abort it. It does not show up with the QuerySession or ShowLocks Utility. When viewing a session that is being blocked, I can identify the blocking session number and Host ID. The Host ID is 0, we use 100...

We do not use access locking on our views. The tables are static, so there is no need to allow "dirty reads". Is there any processing/performance advantage to using an access lock on a view? We do have some very large tables (300+ mill rows) that are hit symultaneously by multiple selects...

I just upgraded my Dell machine from XP Home to XP Pro. After the upgrade windows lost my modem. The problem is discribed in MS Knowledge Base Article 329441. My question concerns their solution. I would like to reinstall SP1, but that is built into the XP CD I got from Dell and can't be...

A couple days ago I went to a presentation on Oracle 10g and Oracle Warehouse Builder. The builder was a very impressive/friendly GUI interface for creating/maintaining PL/SQL ETL scripts. Has anyone used TD Warehouse Builder or seen both? Is the TD application GUI?

I have two questions: I am going to upgrade from XP Home to XP Pro, are there any particular problems/issues I should be aware of? I remember reading about a problem with Service Pack 1 causing slowdowns/conflicts on some hardware. Are there any reported problems with the recently released...

During Phase 1, Fastload loads the data in blocks on the amps associated with the sessions. During Phase 2, Fastload sorts the data by hash on the "final" amp. Question: does fastload distribute the data from the "load" amp to the "final" amp during Phase 1 or 2...

When logging on to multiple sessions using Fastload, Bteq, Arc etc, why does it appear that one session has significant activity, and the others have little activity or are idle? Why bother with multiple sessions?

I have a couple questions concerning table maintenance. I am ultimately trying to provide the fastest inserts while preventing dups. Fastload into a SET table. Fastlaod by design drops duplicate rows. Does using a SET table also involve dup checks during the distribution step? Can I use a...

I am discovering problems with "Hot Amps". Is there any tool or utility to tell which of 4-8 queries is causing the problem?

I am new to Oracle but familiar with ANSII SQL. I am taking a class and the reference book suggested is "Introduction to Oracle SQL and PL/SQL" from University Press. I would prefer not spending $250.00 on a good Oracle SQL reference. I would like a book that could later be used as...

I am new to Oracle but familiar with ANSII SQL. I am taking a class and the reference book suggested is "Introduction to Oracle SQL and PL/SQL" from University Press. I would prefer not spending $250.00 on a good Oracle SQL reference. I would like a book that could later be used as...

We had a 300m row table with all rows being updated that took an unexpectantly long time, especially when we aborted the update and a rollback took place (live and learn). I believe I understand how TD is performing updates, but I would like to review my understanding. There is a Target table...

In another thread dnoeth stated: Never use "csum(1,1)" on a large data set, this will result in a skewed spool with all data on a single AMP. I would like to know why this is true. CSUM(1,1) returns different values on each row; i.e. 1,2,3,4; why would all rows go to the same AMP...