Recent content by Elsebet

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

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

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

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

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

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.

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.

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

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

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

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.

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

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

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?