Ø 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/,如需转载,请注明出处,否则将追究法律责任。