I'm not sure if this belongs in the repliaction forum or the dw forum? I am planning to use Replication to populate my staging database for the dw I'm building. My questions are as follows.
1) Are there any articles on the best steps to use transactional replication to populate and maintain a dw? Especially one that the source database doesn't keep last update timestamps.
2) In the target staging database I only want to have the transactions that I have not applied to the dw yet. This is important since I don't have a way to tell what was updated since the last load to the dw.
3) Is it possible to have the log reader dump the transactions into a database table?
4) If I can't capture the transaction information into a database, how can I update additional attributes I'll need to add to the staging database, to show the transactional timestamp.