A dimension table is one of the 2 primary building blocks of a dimensional data model. The other primary type of table is the fact table. This post will describe 7 best practices for designing a dimension table. What is the purpose of a Dimension Table A dimension table is the primary way to filter and group results from a fact table. A fact table is almost useless by itself, as you need to give some descriptive attributes to provide context to the data....

If you are playing at a blackjack table where late surrender is allowed, you should take advantage of the late surrender rule by slightly changing the blackjack basic strategy rules for when to stand on hard hands. Late surrender allows you to surrender your hand and lose half your bet only after the dealer checks for blackjack. Ask the blackjack dealer at your table if late surrender is allowed. Here are the updated rules for when to surrender....

If you are playing at a blackjack table where the dealer hits soft 17, you need to slightly change the blackjack basic strategy rules for when to double down on hard and double down on soft hands. Here are the updated rules for when to double down. 3 blackjack basic strategy rules for doubling down on hard hands when dealer hits soft 17: Always DOUBLE on 11 DOUBLE 10 vs. dealer 2 thru 9 DOUBLE 9 vs....

There are situations where you need to keep a source and target in sync. One method to do this is to truncate and reload. However this method is not that efficient for a table with millions of rows of data. You really only want to: insert rows from the source that don’t exist in the target update rows that have changed delete rows from the target that no longer exist in the source Can you do this efficiently in a single informatica mapping?...

If you need to denormalize or flatten PeopleSoft summer trees (trees with leaves) in your data warehouse, here is an ETL process for you to follow. Typical PeopleSoft summer tree structure SQL to flatten the PeopleSoft summer tree Substitute TREE_NAME with the name(s) of your summer tree(s) on line 54 below. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 SELECT SQ4....