Soon about too pull out data from different oltp systems which means some
kind of merging dimensions.

I see two approaches

1) my dimension table represents the union between the oltp systems
dimension tables
2) my dimension table represents the contense of the oltp systems from where
it origins and records from other oltp system with unknown dimension values
is dismissed and informed to user

Number 1 I think I can handle but how would one go about making number 2 ?
Would it be a separate sql-task that gets records with dimension values that
doesn't exist and put these into a sql-loggin table ? And another sql-task
which gets records with dimension values that does exist.

\Michael V.