Results 1 for
"coding natural"
No natural key
Hi All, Type 1 SCD contains what I'm calling an holistic help desk ticket, which is an amalgam of a user's problem as it's passed from one helpdesk application to another and so (max of four helpdesk application's in use here). My problem is that the
Hi All, Type 1 SCD contains what I'm calling an holistic help desk ticket, which is an amalgam of a user's problem as it's passed from one helpdesk application to another and so (max of four helpdesk application's in use here). My problem is that the
Fact Table Natural ID
Hi I have a fact table that is populated from one data source and I store the source systems row unique id (single value) in the fact table. However this fact table will now be populated from two data sources, the second data source has a unique key
Hi I have a fact table that is populated from one data source and I store the source systems row unique id (single value) in the fact table. However this fact table will now be populated from two data sources, the second data source has a unique key
DW Key Vs Natural Key ?
I would like to know your opinion of using DW Key is the Data warehouse or dimension tables instead of actual key from OLTP. Please keep in mind that I am not talking about surrogate keys. I work in environment where the OLTP system has surrogate key
I would like to know your opinion of using DW Key is the Data warehouse or dimension tables instead of actual key from OLTP. Please keep in mind that I am not talking about surrogate keys. I work in environment where the OLTP system has surrogate key
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
Surrogate vs natural keys and smart columns
Some of my co-workers have proposed that we use natural keys in our slightly normalized data warehouse table structures. These table will be used to populate our fact and dimension tables. In example, one of our primary key structures would consist of a
Some of my co-workers have proposed that we use natural keys in our slightly normalized data warehouse table structures. These table will be used to populate our fact and dimension tables. In example, one of our primary key structures would consist of a
Hierarchy as Type 2 Change - Use Surrogate or Natural Key?
I realise hierachies have been covered a number of times on here but i've not been able to find an answer to my specific question, but apologies if it has and i've missed it. I just wondered what other peoples experiences are with creating and managing
I realise hierachies have been covered a number of times on here but i've not been able to find an answer to my specific question, but apologies if it has and i've missed it. I just wondered what other peoples experiences are with creating and managing
Business keys or Natural keys in the Fact table
As I have read from Kimball methodology the fact table always contains surrogate keys of the dimensions and the measures. My take away on this is when the reporting is done the entry point to the facts is always through dimensions that joins on the
As I have read from Kimball methodology the fact table always contains surrogate keys of the dimensions and the measures. My take away on this is when the reporting is done the entry point to the facts is always through dimensions that joins on the
Natural Nausea Remedies?
I figure you all might have a trick or two up your sleeves since nausea/vomiting can be one of those annoyances tied to migraines. I had caught a awful stomach bug, and although that has cleared up, the nausea has been lingering for DAYS.. and I dont
I figure you all might have a trick or two up your sleeves since nausea/vomiting can be one of those annoyances tied to migraines. I had caught a awful stomach bug, and although that has cleared up, the nausea has been lingering for DAYS.. and I dont
New Mexico Is Running Out of Natural Gas Right Now
Hi Janey! I belong to a private/invitation only forum and we have been following you news intently and daily. We do so appreciate all your work and for this "landing place" after GLP folded. Would it be okay for me to "re-establish" and continu
Hi Janey! I belong to a private/invitation only forum and we have been following you news intently and daily. We do so appreciate all your work and for this "landing place" after GLP folded. Would it be okay for me to "re-establish" and continu
Do people recommend "natural" remedies to you?
In light of the "white noise" post... lol A lot of well-meaning people who love me call me or send me emails saying, "Have you tried this?" My best friend likes to look for things online to try to help me, bless her heart. Some o
In light of the "white noise" post... lol A lot of well-meaning people who love me call me or send me emails saying, "Have you tried this?" My best friend likes to look for things online to try to help me, bless her heart. Some o
best way for dimension table lookups, if natural key is multi-column (string)
I have a Property table in a Real Estate Database with a compound primary key { company code (varchar), PropertyID (int), Business Entity (int) }. When I am populating the Property dimension table in the DWH, I don't want to have to lookup every single
I have a Property table in a Real Estate Database with a compound primary key { company code (varchar), PropertyID (int), Business Entity (int) }. When I am populating the Property dimension table in the DWH, I don't want to have to lookup every single
Are compound PKs ok for a dimension table?
Would like to get some opinions on this... I've always been of the opinion that dimension tables should have a single surrogate primary key column, and that the 'grain' of the dimension would be defined by its natural key. However, I am now thinking
Would like to get some opinions on this... I've always been of the opinion that dimension tables should have a single surrogate primary key column, and that the 'grain' of the dimension would be defined by its natural key. However, I am now thinking
Comparative Coding Resources
Hi everyone, I figured it might be reasonable to have a listing of which mods distribute their source code, as it might make some of our coding efforts a lot easier if some feature we are intending to code has already been partly implemented in a
Hi everyone, I figured it might be reasonable to have a listing of which mods distribute their source code, as it might make some of our coding efforts a lot easier if some feature we are intending to code has already been partly implemented in a
Coding for Phpbb2
Is the coding different for phpbb2 to phpbb3 i try this code for phpbb2 but doesn't work. Code:a { text-decoration: none; } a[href="/g1-project-toruk-administrators"] {
Is the coding different for phpbb2 to phpbb3 i try this code for phpbb2 but doesn't work. Code:a { text-decoration: none; } a[href="/g1-project-toruk-administrators"] {
Coding in Garry's Mod
Coding in C# is seventy times harder as it is in Garry's Mod's E2 and their lua script. I have yet to study what you could do with Lua and E2 and have not yet found a source to study from. I heard it's sorta easy reading reviews from inexperienced coders.
Coding in C# is seventy times harder as it is in Garry's Mod's E2 and their lua script. I have yet to study what you could do with Lua and E2 and have not yet found a source to study from. I heard it's sorta easy reading reviews from inexperienced coders.
Results 1 to 15 on 181
for "coding natural"
for "coding natural"
Active topics
Popular topics
Unanswered topics
