Fact tables should stand alone. Dimensions can be shared between fact tables.

Create a new fact table with all the information required for the new process. If necessary, seed...

any time you are bringing data into the DW using a Delta you will potentially have records that are not in the Delta. This may be because they are...

but remember that both solutions are only going to migrate the database and data, not any GUI. (please tell me that your Access application has a front-end database with the...

one option would be to have multiple fact tables. this is demonstrated in the AdventureWorks SSAS walkthrough where there is a fact_internetSales and a fact_ShopSales

@ronkyle,

For the standard western collations, NULL appears at the top of the sort values so when you end date the record it will change it's place in the...

I'm not using Cache because I wanted to use the advanced query function

Looked at the package in XML and the fields being reported in the errors only exist once.

Tried viewing the XML of the package in SSDT and running a find - no dice. Will try again with the packages closed.

Pragmatic works have a BI documenter which can crate word docs or html files that document the packages. This might form the basis of that analysis and might be...

Good Luck 😀

I would say, talk to Red Gate. I don' think there is a specific took in the arsenal that allows you to do this, but they may...

Thanks Koen.

On further consideration the default SCD wizard is not an option for me because the source is an ODBC DSN rather than a SQL server.

MergeJoin is OK, because I...

Depending on how strict your regression testing is, you might be better off with four separate packages and a master package that calls the four child packages. If you...

If memoery serves correctly, DB2 is the native database for AS400. you should be able to get hold of ODBC drivers which will need to be installed on your...

Indexing is definately one I would look at. If you have a large number of indexes on the destination table then it will take a while to write the...

Hi Goat and wlcome to the boards...

The problem and requirements are not clear from your post.

Are you saying that you have two files with related data

(e.g. a file of...