Ø  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,

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