ITPub博客

首页 > Linux操作系统 > Linux操作系统 > lookup trans and expression variable use

lookup trans and expression variable use

原创 Linux操作系统 作者:ashleywzl 时间:2013-06-19 17:37:20 0 删除 编辑

Ø  Lookup override query

1.       in this query, must use “as” to define the column, otherwise, Informatica will treat as invalid query.

 

2 .Not support columns in nest query for example:

select 'AA'as A,(select 'BB' from dual) as B from dual;

in this case, change query to use sub query

Select C.A AS A, C.B AS B
  from (select
'AA' as A, (select 'BB' from dual) as B from dual) C

 

Ø  In the mapping level, expression trans,when use local variable

Can only use variable port directly.can not use nest nest variable. For example,

 

port

O

V

exp

status

v1

 

y

aaa'

 

v2

 

y

bbb'||v1

 

c

y

 

v2

FALSE

d

y

 

bbb'||v1

TRUE

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25676270/viewspace-764344/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    65
  • 访问量
    53728