I am not sure I completely understand the question. You have an old cube that has some data that is missing from your data mart and you want to...

Attribute relationships are set up in the dimension editor in BIDS. If you click on the node of an attribute relationship in the designer, the relationship type will be...

During the pre-execute, data is gathered and cached on a number of components. If you are using some lookups in full cache mode, for instance, the cache is built...

Not really, I tried to add to my answer, but there was not much to include.

Replication can't really tell the difference.

Yes

I would agree. The standard is not what I would normally do, but as long as it is consistent, there is nothing really wrong with it.

Just be happy there...

Nice article. I have done this a lot. Another option I don't know if you have considered is using transactional replication. It is nice because it splits...

That's an odd format - no default conversion for it.

So, it takes some string manipulation:

SELECT REPLACE(LEFT(CONVERT(VARCHAR,GETDATE(),13),11),' ','-')

TALLY tables are not temp tables (they do not need to be and are most often not). It is a table used for operations in which you need large...

You cannot use a TEXT data type for a variable. Why do you need it in a variable? What are you trying to do? With what you...

I would not use triggers.

Your plan is somewhat sound, but has a couple of holes. First, replication will send inserts, updates, and deletes one at a time to your...

Use the MS OLEDB Driver for ODBC sources and SSIS to transfer data.

You could very carefully configure the transactions in the package to error and roll everything back, but it is risky. The best solution would be for you to create...

In the SQL 2005 start menu, under configuration tools, there is a Reporting Services configuration GUI. You need to go into this and configure RS before you can use...

You need to do some reading about how to use script tasks. It is pretty easy to add a row to a pipeline.