-
编辑 删除
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...
-
编辑 删除
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...
-
编辑 删除
clob use
clob datatype take so much space ,in the source and target use varchar2(xxx) to replace clob to truncate length.
-
编辑 删除
9.1 parameter file
item1---使用parameter file 设置path,such as :session log ,source path and so on [Global]$PMMergeSessParamFile=TRUE$PMSessionLogDir=/data/informatica/Renewables/WINMF01/SessLogs$PMBadFileDir=/data/inf...
-
编辑 删除
flat file date datatype
当SOURCE是 flat file，且有date 数据,而TARGET oracle table 是date datype,要在transformation中用to_date(xxxx,'xx--xx--xxxx')，日期format要与date数据匹配，而不是与target oracle table date 数...
-
编辑 删除
scripts
upload the scripts into informatica server must be in ASCII mode
-
编辑 删除
fetch parameter value
当一个session用于几个不同的workflow时，在SQ中用到parameter and value take from file ,这里不同用固定的格式， '[WINMF01.WF:' || var_WORKFLOW ||'.WT:'||var_WORKLET || '.ST:' || var_SESSION ||...
-
编辑 删除
sql override
look up transformation or other in sql override -----不需要select from table与transformation可以不一样，而transformation里的port与sql overy里select field ，通过port ,field 顺序与select field as xx匹配...
-
编辑 删除
last load date
setvariable(xxx,sysdate)---这个只有在有数据通过时，才能生效，否则日期不变
-
编辑 删除
applied and affected rows
Applied Rows For sources, shows the number of rows the Integration Service successfully read from the source. For targets, shows the number of rows the Integration Service successfully applied t...
-
编辑 删除
look transformation tune
Persistent cache. If you want to save and reuse the cache files, you can configure the transformation to use a persistent cache. Use this feature when you know the lookup table does not change between...
-
编辑 删除
performance tune in mapping
Complete the following steps to evaluate expression performance: Time the session with the original expressions.Copy the mapping and replace half of the complex expressions with a constant.Run and ti...
-
编辑 删除
截取日期
在informatica 中，取日期的一部分，如月，日，年，可以直接用函数GET_DATE_PART，而不像在oracle，用to_char然后，转换什么的
-
编辑 删除
nvarchar ,nclob with driver ODBC wire oracle
当degug成功，但是test,报莫明的错，改datatype nvarchar2-->varchar2 and so on
-
编辑 删除
lookup transformation
lookup transformation“L” denotes Lookup port“R” denotes port used as a return value (unconnected Lookup only)There can be only one return portUsageGet related valuesVerify if records exists or&n...
-
编辑 删除
some transformation notes_2
All the folders should be closed for assigning workflows to Integration Service Recover -- recovers a suspended Workflow after a failed Task is corrected from the point of failure Abort has a...
-
编辑 删除
some transformations notices
SQ是同类数据源，joiner可以是同类也可以是异类 如果数据源的表来自于不同的数据库，或者有一方是flat file，那么在joiner中，不可以写SQLThe Joiner does not accept input in the following situations:Both in...
-
编辑 删除
Object Shortcuts
Object Shortcuts 首先folder--->edit,options allow shortcut selected 当从那个有手拖着的那个文件夹，copy sth to other folders ,it will shows the below information
-
编辑 删除
repository service
repository service is a multi-threaded process and can run on mulitiple machcines or nodes in the domail.each process is called a repository service process. 一个repository可以位于多台电脑或者n...
