The source table for ETL process doesn't have any IDcolumn! RRS feed

  • Question

  • hello,I want to create a ETL from source to DW. I like to use CDC, but the tables in the source doesn't have ID column,joining of 4 fields make a primary key for the table. If i can not add id column in the source is there any way to do that? what is best practice in this kind of situation.

    Thank you in advance

    Friday, September 13, 2019 1:51 PM

All replies