Results 1 for
"table and column naming conventions"
Stage vs PSA Naming Conventions
I have a little difference of opinion with my current team members concerning naming conventions between Stage and PSA. Int he years that I've been in BI/DW, I've learned that it is the norm that the Stage is basically an extact representation of the
I have a little difference of opinion with my current team members concerning naming conventions between Stage and PSA. Int he years that I've been in BI/DW, I've learned that it is the norm that the Stage is basically an extact representation of the
Quick question about TV poster and banner naming conventions
I'm a little confused about the naming convention for the TV posters and banners. Is the name for a banner season-all.tbn or folder.jpg? Reason being I'm wondering if I can have both the banner and poster as options for the library. I personally used
I'm a little confused about the naming convention for the TV posters and banners. Is the name for a banner season-all.tbn or folder.jpg? Reason being I'm wondering if I can have both the banner and poster as options for the library. I personally used
Star Schema vs All in one table
Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.
Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.
fact table as a dimension
Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both
Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both
INTERVAL TIME SUM COLUMN
Hello, In my data warehouse I have a fact table that joins with calendar table on BETWEEN clause ( calendar.date between myfact.startdate and myfact.enddate ). In calendar date I have a record for each day. I need to sum a fact table column in my
Hello, In my data warehouse I have a fact table that joins with calendar table on BETWEEN clause ( calendar.date between myfact.startdate and myfact.enddate ). In calendar date I have a record for each day. I need to sum a fact table column in my
Dimensional table design dilemma, Aditional column or Xref table
Here is my situation. We have a currency dimension table which stores the ISO currency codes (e.g. USD for US Dollar) and a surrogate key, currency description along with some maintenance columns (insert date, update date etc..). We are trying to
Here is my situation. We have a currency dimension table which stores the ISO currency codes (e.g. USD for US Dollar) and a surrogate key, currency description along with some maintenance columns (insert date, update date etc..). We are trying to
Stacked NFO/Fanart/TBN problem
Hi Billy I downloaded the most recent version 2.085 and am having a number of problems. I read in the anouncement for 2.071 that if I have fanart and poster tbn's not named with the default naming convention then it would offer to rename them for me
Hi Billy I downloaded the most recent version 2.085 and am having a number of problems. I read in the anouncement for 2.071 that if I have fanart and poster tbn's not named with the default naming convention then it would offer to rename them for me
Indicator Dimension or Fact Table
Sorry, this is a long explanation but I wanted to document the entire case. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a
Sorry, this is a long explanation but I wanted to document the entire case. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a
Montly Snapshot views with transactional Fact table w/SCD2
I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with
I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with
DATE OR DATE KEYS IN FACT TABLES
I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date
I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date
New User Extenstions regarding webtable testing.
Hi Guys, I have developed some new user extension to test web table which is not possible from basic commands. so, for you I have develop some and I'm sure this will help u guys to test your applications. Note: This user extension is workin
Hi Guys, I have developed some new user extension to test web table which is not possible from basic commands. so, for you I have develop some and I'm sure this will help u guys to test your applications. Note: This user extension is workin
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
TV File Naming Convention
I'd like some input from folks on how to best store my TV Show library to work with XBMC Media Companion. Right now I have: -Movies --- Movie Name Folder ----- Movie Name.mkv ----- Movie Name.tbn ----- Movie Name-fanart.jpg -TV --- TV Series
I'd like some input from folks on how to best store my TV Show library to work with XBMC Media Companion. Right now I have: -Movies --- Movie Name Folder ----- Movie Name.mkv ----- Movie Name.tbn ----- Movie Name-fanart.jpg -TV --- TV Series
fanart naming
When I have multipart movies like movieX CD1.ext movieX CD2.ext then the fanart file is named movieX CD1-fanart.jpg But for it to work in XBMC it should be named movieX-fanart.jpg if I let XBMC stack the multi-part files. Could you add an optio
When I have multipart movies like movieX CD1.ext movieX CD2.ext then the fanart file is named movieX CD1-fanart.jpg But for it to work in XBMC it should be named movieX-fanart.jpg if I let XBMC stack the multi-part files. Could you add an optio
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
Results 1 to 15 on 352
for "table and column naming conventions"
for "table and column naming conventions"
Active topics
Popular topics
Unanswered topics
