Hi, I will use CDC in SQL 2008 for my SSIS project. I have the below two tables from source DB. Student table ( EntityID int, StudentName varchar ....) Address Table (AddressID, EntityID, AddressName....) I've created CDC on both tables. I have a Dimension in datawarehouse(target), DimStudentAddress (EntityID,StudentName,AddressName) So I use below query to get data for initial loading to the Dimension: Select s.EntityID,s.StudentName , a.AddressName FROM Student s left join Address a on s.EntityID = a.EntityID For incremental loading, I will look at data in CDC tables. As each CDC table is designed for capturing change on single table, if I need to grab change from two tables what is best way to do it. I think if I can create CDC on view, I will solve my problem. But I do not think I can do it now. Thanks Sea Cloud

Hi, I am not sure about CDC, i came across this tip on CDC. Check if its helpful for you. http://blog.beyondrelational.com/blogs/vishalpawar/archive/2011/07/23/bisql-28-audit-trail-part-iv-comparing-entity-framework-and-sql-cdc-for-audit-trail.aspxThanks Karthikeyan Anbarasan http://f5debug.net/