嵌套过滤同步如何实现？

cdshrewd

goldengate过滤的时候如何处理这样的过滤条件：select * from a where a.type in(select type from b),有人做过吗？我以前对这样的情况是建议客户用物化视图做的，
现在遇到一个客户不太认可物化视图的做法，大家有什么好的做法？

lunar

table ytbdata.SO_8600000002010030207000703,  SQLEXEC (ID lookup1,  QUERY "select M1 from ytbdata.V_8600000002010030207000703 &                          where SURVEYOBJECTID = :surveyobject_id and SURVEYOBJECTID =:reportperiod_id",  PARAMS (surveyobject_id = SURVEYOBJECTID, reportperiod_id = REPORTPERIOD), BEFOREFILTER, ERROR IGNORE),  FILTER ( @STREQ (lookup1.M1, "B" ));

cdshrewd

谢谢回复！