lookup trans and expression variable use
Ø Lookup override query1. in this query, must use “as” to define the column, otherwise, Informatica will treat as invalid query. 2 .Not suppo...
保存文件名为年月日
touch $ARCHIVE_PATH/aa_`date +%m%d%y`.dat
flat file content error
error:row[2555] 824th-null in the text fiel,which is donot allowed in the txt fie 是说file里的第2555 行第824个字符有问题,such as source file 里包括header and footer,informatica ...
SQ or Lookup override query issue
when using SQL override,it get error "invalid query" and ask to contact xxx adminbut can get successful in PL/SQL. two ways to check1.valid the query in the DB in informatica tool.2.in...