You are developing a SQL Server Integration Services (SSIS) package that imports data from a
relational database to a data warehouse. You are importing data from a relational table named
Projects. The table has change data capture enabled on all columns. You need to process only the
most recent values from rows that have been inserted or updated since the previous execution of
the package. Which query should you use as the data source?
A.
SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all update old’)
B.
SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all’)
C.
SELECT * FROM cdc.fn_cdc_get_net_changes_Projects (@from_lsn, @to_lsn)
D.
SELECT * FROM cdc.Projects_CT WHERE @from_lsn >= _$start_lsn AND @to_lsn < _$start_lsn
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/bb522511.aspx
http://msdn.microsoft.com/en-us/library/bb510627.aspx
http://msdn.microsoft.com/en-us/library/cc645937.aspx