bit of a departure from my norm I am looking at using CDC from source systems to populate a data warehouse. Currently I am looking at one SQL Server 2008 Database with circa 20 tables. We may add other instances of SQL Server at a later date.
Are the Log Sequence numbers totally unique so if I want to move my changed data with LSN's between 0x00000001 and 0x00000100 then all i have to do is access all 20 Table value functions and each time I pass the same two LSN's
or are the LSN's specific to the capture instance ? I am guessing they are unique for the database where CDC is enabled?
PS are there any pitfalls wityh this apporach to loading a data warehouse? Planning to use net changes in the settings to assist getting the data in quickly.