To answer your question "How do i know the correction/ modification in flat files?"

Use the BINARY_CHECKSUM(*) function, you will need to work through how to "stage" the data. But...

To answer your question in scenario 1, c (all of the above) scenario 2 (Would scenario 1 and scenario 2 be stored in one fact table?), yes could do.

It would...

Yep, you could that.

Or, why dont you use the data mart to report off, or create an aggregate table to report off?  Why do you need the cube?

Cheers

Yeah I was going to go down the same route, thanks for spelling it out though.  The only other issue is that the 3 different instances are on the same...

Hi Eric,

Did some more reading and it does look like you cant do it, as you suggested.

Basicially got dev, test, prod setup and wanted to drop a generic activeX into...