New to BI and need a little help understanding the basic concept
Hi, I apologize in advance if you lose the will to live with my question or if you think it is a stupid one but I am very know to BI with limited SQL knowledge, I have be tasked with developing a BI solution which on the face of it seems small scale

Junk Dimension Naming
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk

Foreign Key Constraints
Hi What is the norm in data warehouses when implementing FK constraints, is it beneficial to create them or not have them at all (SQL Server 2008) Regards Tim

Hand-Coded ETL revisited
Hi I read Gary Nissen's article, 'Is Hand-Coded ETL the Way to Go?', with interest. Given that this was written nearly six years ago, I wonder whether the position has changed i.e. whather ETL tools are now more strongly recommended ober

Guy Garvey Appreciation Thread
Well, there's a Craig thread so why not a guy thread? I don't know what I should write other than - great singer (BEAUTIFUL touching voice) - great songwriter (BEAUTIFUL touching lyrics) - great man (just BEAUTIFUL ) In my opinion. I don't lik

DW Architecture for a new setup
Ok I'm a newby to DW. I am tasked with setting up a data warehouse this year. There are a couple of things which I feel make it unique, I'll outline the plan I have come up with to accomplish this as of right now. We have 2 OLTP systems, one was from

Ability to ignore hidden .avi files
Hello, I am mainly a mac user and manage my movie/tv collection from OS X and use VMware to run MC. The Mac OS creates small files that mimic the file names of your media for preview icons. When MC encounters these hidden files it scrapes them as its

CF Funkey Trunk & Angus Lab
tlcpokertables wrote:Hi there, I don't know much about this game, but my son keeps asking me questions about it....His latest question is, how do I get the portal jammers in the trunk?!? It keeps giving a message "Web registration and internet

Custom Firefox profile doesn't work
Hi there, I try to start Selenium RC with a modified profile for Firefox, but Selenium doesn't take this profile. I searched the web and tried several things, but nothing helped. In the ant-File, I placed the following 2 lines: <arg

PalmImage E-mail problem
I have a PanImage tablet and cannot get it to recognize and connect to my Bellsouth.net Outlook Express e-mail account. The error message displayed is: Checking incoming server settings. Unable to open connection to server. Any suggestions are

Data Warehouse spread across 4 separate databases
Hello, I started with a new BI team. Our data warehouse was developed by consultants. I find the design very strange, but they insist that it uses BI best practices. I can't find any best practices supporting this set-up. Can anyone help me

FACT table Incremental load!
Hi I have huge data source (1TB), that data source table is not well designed, its primary keys are four columns which are all nvarchar! and in that source there is no date filed neither a serial or sequence #! my question, how I can implement an

Add Furry females?
Just a suggestion but as a fur myself id like to see some of the more popular furry girls at least, not limited to but including Trixey - Fox and the Hound Gadget - Resque Rangers Maid Marian - Robin Hood Colleen - Road Rovers Krystal -

Textual fact or Junk dimension?
Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best

Updating Fact Table : Best practice
Hi, Ssystem used : Windows 2003 srv SQL Server 2005 STD for the OLTP SQL Server 2005 Ent for the DW with - SSIS for the ETL - SSAS for the cube ASP.NET control to display the OLAP for the user I know theres is not "one size fits