Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bigscott

    Another reason why Teradata does no

    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...
  2. bigscott

    Future of Datawarehouse

    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...
  3. bigscott

    Should the Data Architect be a business expert or a DBA?

    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...
  4. bigscott

    Another reason why Teradata does no

    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...
  5. bigscott

    Redistribution Spol Space

    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...

Part and Inventory Search

Back
Top