If records for dimension and fact tables never exist in the destination DB, Insert statement should be enough.
Else, if you have to update existing rows and insert new ones, have a look to Merge statement.
