when using SQL override,it get error "invalid query" and ask to contact xxx admin
but can get successful in PL/SQL.
two ways to check
1.valid the query in the DB in informatica tool.
2.in the query,set the select column name(as) to the name in the SQ or Lookup transformation column name
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25676270/viewspace-752484/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25676270/viewspace-752484/