Results 1 for
"surrogate vs natural keys and smart columns"
Non-durable natural keys
Hi all, I'm having an issue with an employee dimension whereby the typical natural key (employee id) is not durable. That being the case, and not being able to use the name as a natural key, I'm a bit stuck as to what I should use for a business key in
Hi all, I'm having an issue with an employee dimension whereby the typical natural key (employee id) is not durable. That being the case, and not being able to use the name as a natural key, I'm a bit stuck as to what I should use for a business key in
A dozen systems with many dimension codes
Hi, I have more than a dozen systems to integrate, and each has it's own version of dimension codes. The source systems need to use dummy codes, and multiple codes for one entity. This for operational reasons. So, to conform a dimension I have a
Hi, I have more than a dozen systems to integrate, and each has it's own version of dimension codes. The source systems need to use dummy codes, and multiple codes for one entity. This for operational reasons. So, to conform a dimension I have a
Surrogate Key Disadvantages??
can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?
can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?
Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
Loading Fact table
Hi, I have following tables FACT, A_DIM, B_DIM. How do I update relationship between a_key and b_key in the FACT table when new record arrives in TYPE2 a_dim dimension? Below is simple create scrip to illustrate what I mean. create table fact (a_key
Hi, I have following tables FACT, A_DIM, B_DIM. How do I update relationship between a_key and b_key in the FACT table when new record arrives in TYPE2 a_dim dimension? Below is simple create scrip to illustrate what I mean. create table fact (a_key
Fact table with non-numeric measure
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Surrogate Key causing incorrect results
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications
Steel Magnolia in full cry...re Ed Smart and Dr Gerald McCann
Ed Smarts good friend Dr.Gerald McCann - 11 November 2010. http://steelmagnolia-steelmagnolia.blogspot.com/2010/11/ed-smarts-good-friend-drgerald-mccann.html The Elizabeth Smart trial taking place as I write, a sham from start to finish. The chosen
Ed Smarts good friend Dr.Gerald McCann - 11 November 2010. http://steelmagnolia-steelmagnolia.blogspot.com/2010/11/ed-smarts-good-friend-drgerald-mccann.html The Elizabeth Smart trial taking place as I write, a sham from start to finish. The chosen
SCD 2 Audit / Metadata Columns
What are the standard audit columns / meta data columns that you will create in a SCD 2 Dimension table. potentially we will get more than one data feed from the same vendor for any given day and we need to track the versions / historical changes to
What are the standard audit columns / meta data columns that you will create in a SCD 2 Dimension table. potentially we will get more than one data feed from the same vendor for any given day and we need to track the versions / historical changes to
SCD2 Type Change Question
Guys, Need your help related to SCD2 type change. I have a table MotorCarrier and we need to keep historical records. The primary key is a column with Identity values (Primary key col name is MCId). There are multiple members belonging to a motorcarrier
Guys, Need your help related to SCD2 type change. I have a table MotorCarrier and we need to keep historical records. The primary key is a column with Identity values (Primary key col name is MCId). There are multiple members belonging to a motorcarrier
Staging Activities
What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single
What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single
rollup fact table
If creating a roll up fact table would you consider using something other than the surrogate key for your date dimension join? I would not but my colleagues think we should be using month_id for example if we are creating a monthly roll up table from a
If creating a roll up fact table would you consider using something other than the surrogate key for your date dimension join? I would not but my colleagues think we should be using month_id for example if we are creating a monthly roll up table from a
Partition Pruning issue
We're looking into partitioning one of our star schema fact tables on Campus Name. The fact table consists of students enrolled by Campus. We're using Oracle 11g. The DBA is saying that we need to add Campus Name to the fact table in order for partitio
We're looking into partitioning one of our star schema fact tables on Campus Name. The fact table consists of students enrolled by Campus. We're using Oracle 11g. The DBA is saying that we need to add Campus Name to the fact table in order for partitio
Natural resources in the Kurdistan region says it covering the salaries of extracting crude oil from fields
Natural resources in the Kurdistan region says it covering the salaries of extracting crude oil from fields Editor: NK | SS | SA Wednesday, 11 August 2010 10:03 GMT Alsumaria News / Erbil The Ministry of natural resources in the Kurdistan
Natural resources in the Kurdistan region says it covering the salaries of extracting crude oil from fields Editor: NK | SS | SA Wednesday, 11 August 2010 10:03 GMT Alsumaria News / Erbil The Ministry of natural resources in the Kurdistan
Converting Columns into Rows.
I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns
I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns
Results 1 to 15 on 114
for "surrogate vs natural keys and smart columns"
for "surrogate vs natural keys and smart columns"
Active topics
Popular topics
Unanswered topics
