Viewing 15 posts - 1 through 15 (of 128 total)
jesse.seymour (9/30/2015)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
November 11, 2015 at 11:44 pm
hegdesuchi (10/2/2015)
I have a requirement where I have to design the SSIS package for both Incremental and Full Load. If I am instructed to run the package as incremental...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
November 11, 2015 at 11:32 pm
Bruce W Cassidy (2/17/2014)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
November 11, 2015 at 11:26 pm
Martin Schoombee (3/18/2015)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 18, 2015 at 8:44 pm
Not sure about ISeries. Sounds like you need to migrate tables.
As for Wherescape -- migration TO wherescape from anywhere will 1.be done manually 2. end up retrofitting the...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 27, 2013 at 10:13 pm
Geert Vanhove (8/1/2012)
Where adding a single column to a table in the Northwind DB during...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 27, 2013 at 10:04 pm
We are using wherescape. Have local Australian MIP helping us out with a few things, but as for myself in particular -- I am learning how to do things using...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 27, 2013 at 9:52 pm
This is very easy. Though not very, but it looks like you need to develop a similar application which would interrogate SSAS dimension(s), allow you to play with it this...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
July 25, 2011 at 5:11 pm
Koen is right. You should create a star schema (ideally) for SSAS to nicely consume tables.
Though nothing (apart from following best practices) stops you from using SQL (Named View) in...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
July 22, 2011 at 12:07 am
or remote into the server, doubleclick on the package (if its saved as DTSX) and run.
You will see the output
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
July 21, 2011 at 7:15 pm
I am not a Essbase specialist, but not sure what you are looking for.
It feels to me you are confusing two things -- building the cube (database, cube, dimensions, deploying,...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
July 21, 2011 at 7:07 pm
1. Read more about the modes of processing and how they work. This bit is usually overlooked by the BI developers and isn't understood very well.
Everyone uses FULL and thinks...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
July 21, 2011 at 7:00 pm
I had same problem with Linked server having SQL Authentication on SQL instance and mapped user in Security Tab of the linked server.
Only an hour later I relized that the...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
May 9, 2011 at 9:43 pm
bigd45 (3/30/2010)
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 30, 2010 at 4:32 pm
huslayer (3/6/2010)
Hello and congrats, did you use any dumps? or how did you prepare? thanks...
NO dumps no specific courses. I got a MS press book preparation to 70-448 and...
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
March 6, 2010 at 8:33 pm
Viewing 15 posts - 1 through 15 (of 128 total)