Displaying 3 results from an estimated 3 matches for "datawarehouse".
2012 Mar 15
3
Adding mean values to boxplots
Hello there,
I was wondering if anyone might be able to help me as I'm pretty new to R.
I'm trying to create a boxplot from a data table returned from an sproc. I
have the following code, which generates the plot as I'd like it:
library("RODBC");
conn <- odbcConnect("datawarehouse"); # connect to datawarehouse
results <- sqlQuery(conn, "call sproc)");
ylab <- 'Percentage (%)'
main = 'Productivity Overview - 6 mnths';
par(mai=c(1.5,1,1,0.2), las = 2, xpd=TRUE, cex.axis=0.8, cex.lab=0.8);
col = c('forestgreen', 'forestgreen'...
2003 Mar 02
1
Rsync problem
...hes). I can copy files between these two
machines (using ssh/scp) fine.
When i run the command:
rsync -rptz --delete --stats --include="*.ini" --include="*.csv"
--include "*/" --exclude "*" --rsync-path=/usr/bin/rsync /directory/data
remotehost:~datawh/datawarehouse
I get this output:
rsync: writefd_unbuffered failed to write 9779 bytes: phase "unknown":
Broken pipe
rsync error: error in rsync protocol data stream (code 12) at io.c(515)
Rsync exits with an error code of 12.
The data in the /directory/data/ folder is all able to be accessed by
t...
2006 Jul 26
15
Rails without a primary key
I''ve been trying to use Rails on a database where the biggest
datawarehouse-style table doesn''t have a primary key. It really
doesn''t make sense and just adds extra unnecessary space. I do have,
however, a column that I normally use to search on (IP) that returns
many rows. The table also references several other tables through
rails-friendly foreign k...