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: *

  1. Elsebet

    Quantifiers and Absolute Words

    Lots of events can be dangerous in some situations, and safe in others. Sitting quietly in your home can be dangerous if there is a tornado overhead. A roller coaster ride can be dangerous if the structure has not been inspected and maintained. Both of those events, under ordinary...
  2. Elsebet

    back to school

    I'm a Devry Columbus grad (2001) and haven't had any real issues with employment. In fact I was hired full-time in 1998 with only 1 year of school completed, and worked through the remainder of my education there. A lot of people look down on DeVry for many reasons, some of which include the...
  3. Elsebet

    Instant vs. Instantaneously

    The second sentence contradicts the first. In the first you are "instantly taken" which infers you were instantly (no perceived time) transported from the laboratory to the alien planet. If you worded it "and instantly began a journey to another planet" then the second sentence would play...
  4. Elsebet

    Although vs though

    http://dictionary.reference.com/search?q=although Specifically: Usage Note: As conjunctions, although and though are generally interchangeable: Although (or though) she smiled, she was angry. Although is usually placed at the beginning of its clause (as in the preceding example), whereas...
  5. Elsebet

    Are you better off now than you were 5 years ago?

    In 2000 I had a very stable job at a major pharmacuetical company and while I still had to do a little mainframe support I was moving into VB/Oracle and Data Warehouse environments. I landed that job in 1998 solely as a result of the Y2K mess. I was working and attending school full-time and I...
  6. Elsebet

    Inmon versus Kimball

    Good read, thank you for posting. While I tend to agree with the author, keep in mind this was written by the president of the Kimball Group and thus isn't a wholly unbiased review.
  7. Elsebet

    Word Sandwiches 3

  8. Elsebet

    .htaccess/.htpasswd a file not a directory..

    I am just learning php, however from what I read you need to create a directory, use .htaccess to protect that directory, then put your .php file in that protected directory.
  9. Elsebet

    Wordplay jokes

    Stolen from http://www.jjonline.com/microSites/ringing/handbellPuns.php, and also read in a recent issue of Reader's Digest: A Short Pun Historical evidence has been found that William Tell and his family were avid bowlers (known as lawn bowling at the time). However, all the league records...
  10. Elsebet

    Surrogate keys & join performance

    When you ask about advantages of staging area and ODS, do you mean compared to a data warehouse? I'll assume such for my response, but correct me if I'm wrong. An ODS is typically set up for a smaller data set than a data warehouse, and expected to answer queries with fast response times...
  11. Elsebet

    Validating data approaches

    What do you wish to validate the data against? The source system? Staging? If it's the source system, perhaps there are existing reports based off that source system you could compare. I know for a project where I recreated mainframe-based reports in an Oracle Reports/DW platform I did a lot...
  12. Elsebet

    Modeling for HR data

    Chapter 8 of Kimball's "The Data Warehouse Toolkit" covers modeling HR Management data. Basically he suggests a Type 2 SCD (as johnherman said above) for the Employee Dimension (Attributes), an Employee Transaction Fact Table, and Date/Time/Transaction Type Dimension tables.
  13. Elsebet

    ETL Tools selection

    Hmm, on quick question from everyone. Is there any ETL tool available for some basic [not-so-transformation-oriented] work which can be acquired in a budget of below 20K $$ If you are using Oracle, their Warehouse Builder is $5,000 per seat base price, I believe...
  14. Elsebet

    Surrogate keys & join performance

    From my experience an integer surrogate key speeds up join performance since it usually replaces a longer or character-based natural key, thus reducing disk I/O. It also may speed up indexing on that column for the same reason. Here are some articles (google is your friend) ...
  15. Elsebet

    Error: SP2-0317.....anyone know what this means?!?

    Can you post the code? Also, was a line number given with the error? Have you tried to compile it in a software package like TOAD or Enterprise Manager? Did it work before and is only now giving the error, or is this the first compile attempt?
  16. Elsebet

    Checking return code results in directory listing?

    Rod: That did it! Thank you so much! Just for the record, changing the DDL had no effect.
  17. Elsebet

    Checking return code results in directory listing?

    Hi Vlad: Moving the ) didn't help, unfortunately. Thanks for the tip though. Hi Rod: I did comment out the echo, however the directory listing ceases to show up (along with the error message I want). Basically none of the Unix scripts that load our DW have any automatic error checking...
  18. Elsebet

    Moving vowels

    Also: SACK SECK (did find this on dictionary.com) SICK SOCK SUCK
  19. Elsebet

    Moving vowels

    BAT BET BIT BOT BUT I wanted to use H_T but HET is not really a word, all the others check out.
  20. Elsebet

    Checking return code results in directory listing?

    Hi all - I am getting rather odd behavior with this tiny piece of code. I'm basically trying to check the result of a sqlplus session with a korn shell script. It does work, however the echo $ret_code not only echos the error message I want but also a listing of the entire current directory...

Part and Inventory Search

Back
Top