jesse.seymour (9/30/2015)

---

The big problem I am facing with all that is that I am having a hard time keeping my thoughts organized, and am constantly second guessing myself. In...

hegdesuchi (10/2/2015)

---

Hi,

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...

Bruce W Cassidy (2/17/2014)

---

Something to be aware of is that an ODS is often "operational" (which usually means it has an up-time requirement of 24x7), and for that reason it...

Martin Schoombee (3/18/2015)

---

I do think there is some caching (or cache warming) going on the first time you connect, but I don't think all the calculations have to be verified...

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...

Geert Vanhove (8/1/2012)

---

As a DBA responsible for a 4TB DWH, WhereScape scares the shit out of me.

Where adding a single column to a table in the Northwind DB during...

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...

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...

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...

or remote into the server, doubleclick on the package (if its saved as DTSX) and run.

You will see the output

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,...

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...

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...

bigd45 (3/30/2010)

---

Did transcender cover very subject that is on the exam. I did know when I took the 2005 it did not cover every subject. There were things in 2005...

NO dumps no specific courses. I got a MS press book preparation to 70-448 and...