Issue

How do I resolve this warning?

Warning: W_JR00B3: None of the specified tables are in both location 'loc_src' and 'loc_tgt'. A table is in a location if action 'Capture' or 'Integrate' is defined and 'TableProperties.Absent' is not defined.

Environment

Local Data Processing

Answer

The warning message below indicates that 'loc_src' or 'loc_tgt' location doesn't have a /Capture or /Integrate action defined on it.

The source location should have a /Capture action and the target location should have an /Integrate action even if you don't run CDC and you're just doing refresh.

Adding the /Capture action on the channel on the group and will resolve this issue.