There is a circularity in the dataflow between operators.

[VIDHATHA]

Hi All,
My job got aborted by giving of error "There is a circularity in the dataflow between operators." .if i run the same job by adding of APT_DISABLE_COMBINATION=TRUE its running continuosly and not giving any result. iam comparing source data with target using Change capture stage in that job.can you please help me on this.

Thanks.

[chulett]

Detail your job design, please.

[rameshrr3]

IS the (source,change) OR reference data(before) and target the same object ( FILE or Database table ) ?

Combining operators will create circularity because of references within a single process , disabling combination shoudl ideally allow process isolation. That could explain what you see. Why don't you use a temporary dataset as a target and load it to the real target in a seperate job ?
Or alternatively - create a dataset for reference data (to compare source against )

[ray.wurlod]

Short answer: design your juob such that there is no circularity of operators.

To be honest, I'm surprised that such a job passed the pre-compilation checks.

Without knowledge of your job design it is impossible to say more. We await your response.