ETL学习笔记（一）

1.InStrRev Function
  Description:  used to find the position of an occurrence of one string within another, from the end of string.
  Return: Position of the first occurrence of one string within another string.
  Syntax: InStrRev(stringcheck, stringmatch[, start[,compare]])
  Example: InStrRev(Fields("Field1"), "$", -1)
           应用在: sale price $14.00
           Return: 12

2.Map Designer中的数据类型，ASCII(Delimited) 是一种用特征分隔符分割每个field和record的数据格式。

3.Map Designer中的onDataChange选项
  Click the down arrow by the box to the right of the Data Change Monitor cell and select Fire first ODC event/Suppress extra ODC event on EOF.
This tells the Data Change Monitor to fire the event on the first data change but not to fire an extra event at the end of file.