A multi cube project is the preffered choice to support different line of businesses within a job function

opc.three (4/10/2012)

---

The 1TB in 30 minutes example was leveraging parallelism within SSIS. If you're using a foreach loop then you're making SSIS single-threaded. Since you have a varying number of...

What you must understand here is that this is not SSIS. Instead you could have chosen tasks such as Merge Join etc

Stumped...

Aah...you remember

Try this a no script component/task solution

Insert the data with 3 derived columns each having a default value as stated. No evry row will have the default values for 3...

Jon consider a case where Support Hours Brought is NULL, in this case the expression would evaluate to NULL - {numerical value}.

Change the true part of IIF to "0"

Hello Jon,

Can you give your complete MDX? It would be lot easier to understand. Also, how are you populating the "Total" field and why are there two numerical columns in...

Is this task been taken up by anybody. If not, I can do it.

How do you know, it is ignoring the IIF.

Can you give some more samples?

The values H, ZEDI and 850 should be inserted for every row, this can be achieved using a DERIVED COLUMN transformation in SSIS

Do you permissions to run DDL and DML comnands on the table. If yes, have you considered adding a trigger?

Also, is the load incremental or full?

There should really be nothing as "stage database". It should be stage tables.

Think of them as an area where the BI professional would perform all the cleaning, integrating and reconciliating...

Using ETL tools a BI professional can integrate, reconciliate and clean data. 🙂

Good to see all adding their views to make the article more clear and precise. Thank you.