The configurations are applied top to bottom.

This is useful if you have an indirect configuration:

You have stored all your configurations in a SQL Server table (or an XML file if...

halifaxdal (1/15/2014)

---

I am working on a Dundas Dashboard project, DD allows user to connect to a database using a different domain id as long as the id's password is pre-inputted...

Not that I can think of.

Which version of SSIS?

Are you sure the build succeeded? Check the output window.

Maybe there is excessive locking? Any other processes accessing the tables?

With SSIS you can use the Lookup component to easily verify if a row from the staging table is an insert (new row) or an update (already existing row).

Write only...

blasto_max (1/14/2014)

---

AFAIK, ETL integrates data from a fixed number of sources/tables. Is it possible that ETL can integrate data from an unknown number of tables which might be added in...

It is not mandatory, but if you don't specify any relations, you must define them yourself in the dimension usage tab of the cube.

In my opinion it is easier in...

EDIT: SSC flipped and accidentally double posted my reply

brandonmichaelhunter 57708 (1/14/2014)

---

Thanks for the book references....I was wondering if had move each cost into their seperate tables, where the budget costs is record 1st of every month and the...

stevefromOZ (1/14/2014)

---

Personally I'd go with the separate table approach "now". You know you're heading that way anyway, the overhead of introducing it now is minimal compared to how you're going...

Because budgets and actuals are not the same thing.

If you want to compare them (for example to calculate variances or KPIs), querying becomes much more difficult if you store them...

You should definately store them on the same row in different columns.

Of course, database corruption can lead to inconsistency.

Lempster (1/14/2014)

---

Koen Verbeeck (1/14/2014)

---

Option A doesn't seem directly to be a good idea, as this requires two surrogates keys in the fact table. However, only one of those two can...