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!

  • Congratulations SkipVought 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: *

  • Users: rmkg
  • Order by date
  1. rmkg

    ETL Tools selection

    Yes, Enterprise licence for Win2k OS and up to 4 processors. We will be having a Dev & Test, yes, but the enterprise license allows for three instances. Do you know the basic differences between the enterprise and departmental licenses? And don't worry Artichoke, we'll haggle! Be nice to...
  2. rmkg

    ETL Tools selection

    Peter, Well, we think it's difficult, which may not be the same thing! We have a need to calculate the total duration of a number of events that may overlap, so our current (hand-coded) processing loops through, altering the start and end dates and times of the appropriately-ordered events...
  3. rmkg

    ETL Tools selection

    For better or worse, this thread is all my fault as I asked my colleague ADB1 to raise the initial question for me. Hopefully the above won't have put everyone off, because I wanted to ask icecore for a follow-up on his BO eval - how far have you got, icecore? We're in the middle of one too...
  4. rmkg

    Index or statisitcs - which comes first?

    Thanks, Dieter, very helpful. I'll have a think and probably get back to you! Richard.
  5. rmkg

    Index or statisitcs - which comes first?

    Hello. In a general attempt to improve peformance, which is the best approach? i) Analysing load scripts to see which columns are hit most, indexing the top X many and collecting stats. ii) Analysing report scripts to see which columns are hit most, indexing the top X many and collecting stats...
  6. rmkg

    Comparing tables

    Good news and bad news. r937 - you beauty! Works a treat. tlbroadbent and tdatgod - union doesn't appear to work. May be a teradata-specific (or even Queryman? unlikely?) problem, which I may refer to the correct forum - error messages: Syntax error, expected something like a Word between...
  7. rmkg

    Comparing tables

    Is there a 'compare table' command so you don't have to nominate every column individually? If not in ANSI, then specifically in Teradata SQL? Thanks.

Part and Inventory Search

Back
Top