Search results for query: *

Thanks for the feedback. We just moved from V2R4 to V2R5. In using a BI tool in front of Teradata, sometimes there is not as much control on the SQL side, you go with the generated SQL. But some of my point is why should an SQL person have to know about redistribution within a query? SQL was...

Althought nobody "knows" the future, data warehousing is looking promising. More and more corporations are building data warehouses every year. There has been a pretty good job market compared to some of the other desciplines. You can get pigeoned holed somewhat because the warehouses...

Interesting question, but I think there is no definate answer. It depends upon the individual. Some DBAs enjoy the business side (modeling of business rules) and make the transaction very easy. Some Business Experts are able to pick on on modeling techniques and become great modelers). But a...

Another reason why Teradata does not work well in normalized environment....... Maybe Star Schemas work better ???? When executing a query containing equijoins, Teradata will redistribute spool files based upon join conditions. If you are joining a very large fact table to a smaller attribute...

Liam The only way to "calculate" this is to understand what the join condition that is forcing a redistribution. For example, I join customer transactions to customer, redistribution is fine. But if I join customer transactions to customer region (North, West, South, East) then...