Search results for query: *

Thanks dnoeth. Can you point me to some other system tables or views that I can check out. I am recent entrant to Teradata world , having been in Oracle for years previously. If there is useful websites that I can use please let me know. How to find out all the systems tables etc. that I can...

dnoeth: In your reply you mention ... "If you're running V2R5 try the Index/Statistics Wizards ..." How do we find which version is runnig? Thanks in advance

I am using bteqwin. I want to find out which version of teradata rdbms / software is running. Is there any command I can use from qteq or queryman? Thanks in advance!

The fact table has a multipart primary key. The parts are the dimensions primary keys. For each record in the fact table there is a unique combination of dimension keys which is multipart primary key. So the Fact as such does not need another column as a primary key. Be Diligent! DWTECH

What information do you need? Be Diligent! DWTECH

check this site http://www.olapreport.com/. Be Diligent! DWTECH

If it is a one time work then you are probably better off writing C/Perl/awk scripts. If it is a regular scenario which has to run as batch job then check out Ab Initio. http://www.abinitio.com/ This tool is expensive but is tailormade to carry out the complex transforms and handle very large...

Well, judging by the fact that your question is 2+ weeks old and still unanswered I think there is no one with answers to your question. Since this is a Oracle specific question try the Oracle user group sites likes technet.oracle.com etc. Try a generic search on the search engines also. Best of...

Hello: This scenario in very common in customer segementation and householding etc. To handle this you need to create a look up or account range dimension table with columns RANGE_ID (Key) RANGE_HIGH_VAL RANGE_LOW_VAL RANGE_DESC This table will be populated everytime you do your batch load...

I think you are keeping the month level data in the "Tot_no_conf" FACT table . In the "mtg_by_month" DIMENSION keep the records with different id for months of each year, starting with the earliest record you are loading i.e keep different id for Jan2002, Jan2003 etc. You...