|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
ETL tables advice Posted by Stephanie at 3/29/2007 3:24:01 PM We have a fairly large BI database on SQL Server 2005. The whole thing takes
up just short of a terabyte right now. This is a project that was started
before I came along and of course I have now inherited it.
Currently we have EVERYTHING in one database. The ETL tables, the ETL
stored p...more >>
Design datawarehouse schema Posted by locusta74ster NO[at]SPAM gmail.com at 3/26/2007 8:54:29 AM Hi,
I need to design a datawarehouse for the manufacturing industry. I'm
sure that this has been done a dozen times, and I was wondering if
there are workgroups where I can find a sample schema, reports and
others?
Looking forward to your reply,
Dirk
...more >>
copying data oracle2sql Posted by Ramunas Balukonis at 3/23/2007 5:10:56 PM Hi,
I discovered that copying data from oracle using "openquery" with linked
server is sevaral time slower that using "dtsexecui" (dts import/export
wzard). I used the same query for both methods. Does anybode has expirience
solving slowly openquery behaviour? My linked server has "allow in proc...more >>
data warehouse truncate question Posted by Mike at 3/20/2007 12:27:24 PM have an SSIS project and I have a package that drops and creates the
database, creates tables, then I have a package that loads the data into the
data warehouse. Now, I got the request in to only load the data and not drop
and create the database every time the package runs due to the package is...more >>
Data transfer between sql server 2000 databases Posted by Balaji at 3/16/2007 9:11:03 AM I have a SQL Server 2000 Enterprise Edition database TestDB1 with 23 tables
that gets populated by replication from a mainframe server. (Inserts,
Updates, Deletes)
Now we have to move the data from TestDB1 to TestDB2 on the same SQL Server
machine. (Same instance of SQL Server) TestDB2 will...more >>
dimension question Posted by John at 3/15/2007 12:00:00 AM I'm creating a datawarehouse and I have a question on a date dimension. My
users want to see the date formatted as such yyyy-mm-dd so they can sort on
it. How can something like this be possible? I never did this so I'm new to
the datawarehouse - cubes - dimension things.
...more >>
how does ado.net SqlDataReader.GetString() know which encoding to read the Posted by Daniel at 3/7/2007 5:25:57 PM how does ado.net SqlDataReader.GetString() know which encoding to read the
data into a string as? Does sql sever set this at the column data type
level, server wide encoding setting, os encoding?
...more >>
Using addextendedproperty in DB for documentation Posted by Joe at 3/7/2007 11:55:41 AM We are using Kimball templates to model our Dimension/Fact schemas in an =
Excel sheet. It allows us to captre extra columns per row such as, =
"Source System", "Source Table", "Source Field Name", etc. Then it =
generates a script to run in t-sql to create the given table with the =
column na...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Joining cubes Posted by Gilgamesh at 3/6/2007 6:50:02 PM I have three cubes in AS. How can I have a separate cube which can retrieve
data from these three cubes and then (similar to join function in T-SQL)
can join the results?
Thanks,
Gilgamesh
...more >>
Cannot insert rows to fact table and processing does not end Posted by Marc at 3/6/2007 6:43:08 AM Dear all
I experienced a problem wit a SQL Server Datawarehouse I want to report to
the community. I have a table with a unique unclustered index. A SSIS package
fills this table during load time. In this package I use a OleDB Destination
Data Flow item to fill the table, this with the opti...more >>
SSIS - adding line numbers to imported data Posted by sqllearner NO[at]SPAM hotmail.com at 3/5/2007 10:45:58 AM I need to import a flat file as follows:
Column1,Column2,Column3
1,2,3
4,5,6
(snip)
123,456,789
Downloaded from www.abcdef.com on 02/28/2007. Total1: 12344556
Total2:
234523 Total3: 56456 Copyright 2004-2007 by ABCDEF Group LLC. All
Rights Reserved.
The last line is some kind of sig...more >>
what is MQs in Ab-initio Posted by mansurkhan at 3/4/2007 5:14:39 AM HI
I am Mansur currently serching for a job on Ab-initio.
In the recent interview i was asked a Question what is MQ ?
So please let me know what is it.
regards
Mansur
...more >>
Surrogate Key and Deploiement Posted by MIB at 3/1/2007 5:29:10 AM Hi,
In my project, for each table i used a surrogate key in my dev
envirronement. Now i want to deploy my database and my reports. But i have
few report wich are based on a particular surrogate key, and this key is
different between the dev and the production. What should i do, because if in ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |