Viewing 15 posts - 4,846 through 4,860 (of 11,678 total)
OK, then your problem looks a lot like a many-2-many issue.
So you could try to model your dimension as a many2many dimension in SSAS.
September 16, 2013 at 7:20 am
Phil Parkin (9/16/2013)
...the performance of your package will plummet
Nice alliteration!
Yes ... that was totally my intention ...
😀
September 16, 2013 at 6:59 am
Richard Warr (9/16/2013)
September 16, 2013 at 6:55 am
Here's a video on how to implement the OLE DB Command:
SSIS OLE DB Command Transformation
Basically you are issuing an UPDATE statement for every row. In the editor, you map columns...
September 16, 2013 at 6:44 am
Why don't you use the ID field of the groups-account dimension as a surrogate key in your fact table?
September 16, 2013 at 5:53 am
jasona.work (9/16/2013)
(ducks behind fresh built snow fort. And people *LAUGHED* when I bought a snow making machine!)
I bet they are still laughing...
😀
September 16, 2013 at 5:49 am
At what rate is the data refreshed?
If it's only daily, you can run a snapshot early in the morning the generate the report.
It will take some time to transfer the...
September 16, 2013 at 3:29 am
The question itself is great, however the explanation is lacking.
There's no reference, and the explanation itself is incorrect.
There's no variable that is "reset".
The DECLARE is not ignored, it is interpreted...
September 15, 2013 at 1:39 pm
debbiekitzke (9/13/2013)
thanks for the response.Yes I am going to have to use a temp table as our DBA area frowns upon lots of "staging" tables in the database.
If...
September 15, 2013 at 1:24 pm
spectra (9/13/2013)
2. Make a backup on the source and restore this on the new instance.
How to make a backup ? this part is not clear.
The article I linked to...
September 13, 2013 at 5:59 am
WITH AuditData AS (
SELECT *,
RN = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY [Modified On] DESC),
max([Modified on]) OVER(PARTITION BY ID) AS [Max Modified On]
FROM @Audit
)
SELECT [ID], [Owner], [Modified on], [Value], [Max...
September 13, 2013 at 5:09 am
Duplicate post. Original post with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1494482-145-1.aspx
September 13, 2013 at 3:24 am
Tom Brown (9/13/2013)
DECLARE @StartDate DATETIME;
SELECT @StartDate = DATEADD(year, DATEDIFF(year,0,GETDATE()), 0);
-- This clause is just to get some numbers: a Tally table, for joining to get a range of dates
WITH...
September 13, 2013 at 2:22 am
Here you go:
-- Set the first day of the week to Monday
SET DATEFIRST 1;
-- create the current year
DECLARE @YearStartDATE = CONVERT(DATE,CONVERT(CHAR(4),YEAR(GETDATE())) + '-01-01');
DECLARE @YearEndDATE = CONVERT(DATE,CONVERT(CHAR(4),YEAR(GETDATE())) + '-12-31');
WITH CTE_FullYear AS
(
SELECT...
September 13, 2013 at 1:41 am
Are you asking which will be faster: the view or the table?
A view is basically just a stored SELECT statement on one or more tables.
To get the data out of...
September 13, 2013 at 1:11 am
Viewing 15 posts - 4,846 through 4,860 (of 11,678 total)