Hi @cgrant,
Thanks for your checking, Could you please help me review on this?I also did the disjoint predicate here is my condition for merge,
[
'target.ClientCode = source.ClientCode',
'target.ReportingPeriodCadenceID <=> source.ReportingPeriodCadenceID',
'target.ReportingPeriodID <=> source.ReportingPeriodID',
'target.ClientCode = source.ClientCode',
'target.AccountReferenceID = source.AccountReferenceID',
'target.ReportingPeriodID = 867',
"target.ClientCode = 'AMEX'"
]
I specific two columns that is clustered by before ('target.ReportingPeriodID = 867', "target.ClientCode = 'AMEX'") but still failed with the same issue.
