What Scott suggested is the way I would do it.

"Intelligent" numeric keys derived directly from other data (without any lookups) can only work in very limited circumstances I think -...

Sorry but if you care about what the...

Use ROW_NUMBER() for surrogate key assignment and order on the natural key. As long as you receive the same data set each time the surrogates will be the same.

Better still,...

In principle, yes. In practice it depends on what special functions or properties you want to assign to a primary key.

In the relational...

Golfer22 (8/11/2013)

---

Here is the definition of 3NF:

"A relation R is in 3NF if and only if (i) it is in 2NF and (ii) whenever X is a set of attributes...

Golfer22 (8/10/2013)

---

About.com says this:

"In order to be in Second Normal Form, a relation must first fulfill the requirements to be in First Normal Form. Additionally, each nonkey attribute in...

Golfer22 (6/8/2013)

---

Please confirm the following:

If a non-key attribute is dependent on one of 1,000 columns (when the primary key is composed of 1,000 columns), the table is in 1NF or...

rka,

Your strategist is quite right that a dimensional model is not a requirement or a complete solution for a data warehouse. Dimensional models are designed very specifically for data marts...

In logical terms there is absolutely no difference. A key (i.e. a candidate key) is a set of attributes which is required to be minimally unique and does not permit...

Seems like a very unwieldy approach. Why can't you just store the starting and ending dates for each price point?

mirde (8/22/2012)

---

I am going to opt-in on using SK's across my Dimensions just to get practice on using them as some dimensions might not have a business key available, thus...

Ankur Bajaj (8/22/2012)

---

Guys, thanks for your inputs. I have created the below script which serves my purpose for now.

Cheers!

SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + '...

Low market share? That's a difficult thing to quantify in a useful way. Gartner...

akirajt (7/7/2012)

---

Should the surrogate key, for instance customerKey for dimension customer, be created in the stage process and then the all data should be loaded into the dimCustomer or should...

htiteuf (5/23/2012)

---

Hi,

Hope it's the right forum!

With PDW AU3, I know stored procedures are supported but some functions in the SMP SQL Server product have not been implemented in SQL Server...