i am new to odi,i am at confussion while working with consistent cdc,in my source two table suppose emp,dept there is fk_pk relationship,i enable journalised data only for dept,if suppose
i make any changes on emp,suscriber capture changes or not,what is extend window,why do we lock the subscriber,please give me some clarification
The question is not clear from your post. Looks like you want to know that in case of consistent set CDC would the changes be captured if the data is changed in only one of the table. Yes, it should capture unless you customize the JKM to behave differently.
You can get more details on ODI CDC at Working with Changed Data Capture - 11g Release 1 (11.1.1)