INFA杂记

1，Update Strategy组件 经常和Lookup组件 IIF(ISNULL(LKP_ROW_WID),'INSERT','UPDATE')

2，When you create a session, the Workflow Manager checks the mapping properties. Mappings dynamically pick up
changes to shortcuts, but not to reusable objects, such as reusable transformations and mapplets. Therefore, if
you edit a reusable object in the Designer after you save a mapping and before you create a session, you must
open and resave the mapping for the Workflow Manager to recognize the changes to the object.

When you edit a mapping after you create a session with multiple partitions, the Workflow Manager does not
invalidate the session even if the changes violate partitioning rules. The Integration Service fails the session the
next time it runs unless you edit the session so that it no longer violates partitioning rules.

3，Informatica可以在source/target definition中自己定义主键（可以多列）即使数据库中并没有设置相应的primary key.
Infa根据设置的主键生成Upadate和Delete语句
INSERT statement:
INSERT INTO WC_POSTN_COACH_A_TEST(ORG_WID,MONTH_WID,DSM_POSTN_WID,SR_POSTN_WID,POINT_AVE,POINT_SCOPE,COACH_TYPE_CD)
VALUES ( ?, ?, ?, ?, ?, ?, ?)
UPDATE statement:
UPDATE WC_POSTN_COACH_A_TEST SET ORG_WID = ?, DSM_POSTN_WID = ?, POINT_AVE = ?, POINT_SCOPE = ?, COACH_TYPE_CD = ?
WHERE MONTH_WID = ? AND SR_POSTN_WID = ?
DELETE statement:
DELETE FROM WC_POSTN_COACH_A_TEST WHERE MONTH_WID = ? AND SR_POSTN_WID = ?

如果插入的数据违反了Tabel的primary key/unique key/unique index等限制，数据会被reject到BAD文件，不会报错，Session显示Succeeded。
如果数据库中的column比INFA中的target definition少，则会报错，Session显示Failed。

分析Session执行结果：
Update————Update else Insert:
WRT_8039 Inserted rows - Requested: 1          Applied: 1          Rejected: 0          Affected: 1          Mutated from update: 1        
WRT_8041 Updated rows  - Requested: 12         Applied: 12         Rejected: 0          Affected: 12

4，SQL没有order by子句的，每次执行返回的数据顺序不是一样的（not  repeatable）（第一次执行不知道什么顺序，第二次执行好像是按照第一列升序排列的）
ETL是按照Source数据顺序抽取的（如果没有特殊处理），所以清空维度表数据重新抽取会导致生成的维度表ROW_WID不一样，
从而事实表中的历史数据需要更新。

5，Email功能：
atbv@163.com,yaq@163.com,lihz@163.com（linux用,windows用;）

Dear Global team, \n
 KPI flat files for the month -$$CaptureMonth_Name, are attached as a zip file. \n
Regards
QYQ

%a<$PMTargetFileDir/globalmart$$CaptureRunTime.zip>

6，flat file source用csv，txt（xls源文件需要用relation source通过ODBC连接），flat file target可以用xls，txt,csv

 

7，

Navigator Pane is Not Coming in the Workflow Designer Window
Solution:
1. Open Registries from Start > Run >Regedit
2. Navigate to the following register: 'HKEY_CURRENT_USER\Software\Informatica\PowerMart Client Tools\<Power-Center Version>'
3. Take an export of the Registry Key >Workflow Manager
4. Click Register > Export Registry
5. Right Click on the registry entry Workflow Manager and click Delete
  (if Designer can not work ,delete Designer Registry Entry )
6. Close the Registry Entry
7. Start the Workflow Manager and check if you are able to view the Repository Navigator.
And now it's working.