Informatica使用查找表Lookup Sql Override属性时遇到内部错误如何解决？

0
映射中使用了查找表的Lookup Sql Override属性：
 
select lkp.source_id

,lkp.delete_flg

,lkp.sys_bsn_key

,lkp.src_create_dt

,lkp.src_update_dt

,lkp.src_crt_by_id

,lkp.src_upd_by_id

,lkp.w_insert_dt

,lkp.w_update_dt

from bidw.tf_mom_rtv_order lkp

,dw_stage.tt_rtv_detail rtv_detail

where 1=1

and lkp.source_id=rtv_detail.source_id

and lkp.sys_bsn_key=rtv_detail.sys_bsn_key

会话日志：
消息代码: DBG_21263
消息: Invalid lookup override
消息代码: TE_7017
消息: Internal error. Failed to initialize transformation [LKP_mom_rtv_order]. Contact Informatica Global Customer Support.
2017-06-14 添加评论
分享

没有找到相关结果

    已邀请:
    0

    wffger 2017-06-14 回答

    修改语句如下则可成功运行任务：
    select lkp.source_id as source_id
    
,lkp.delete_flg as delete_flg
    
,lkp.sys_bsn_key as sys_bsn_key
    
,lkp.src_create_dt as src_create_dt
    
,lkp.src_update_dt as src_update_dt
    
,lkp.src_crt_by_id as src_crt_by_id
    
,lkp.src_upd_by_id as src_upd_by_id
    
,lkp.w_insert_dt as w_insert_dt
    
,lkp.w_update_dt as w_update_dt
    
from bidw.tf_mom_rtv_order lkp
    
,dw_stage.tt_rtv_detail rtv_detail
    
where 1=1
    
and lkp.source_id=rtv_detail.source_id
    
and lkp.sys_bsn_key=rtv_detail.sys_bsn_key
    2017-06-14 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册