Informatica变量VARIABLES研究.docVIP

变量VARIABLES 特性： 在每次SESSION中可以改变，在SESSION成功后 Integration Service 保存变量的一个新值，并且下次再运行SESSION时你可以使用这个变量值。 如果你定义一个变量叫$$State 你在Source Qualifier里面使用 你用STATE = $$State 如果变量值为ONUSE 那么解释为 STATE = ONUSE 在其余的中间组件里面 你用STATE = $$State 如果变量值为ONUSE 那么解释为 STATE = $$State Integration Service保存2个值为每个mapping variable当SESSION运行中: Start value of a mapping variable Current value of a mapping variable Variable Functions Variable Function Valid Aggregation Types Valid Datatype SetVariable Max or Min All transformation datatypes except binary datatype. SetMaxVariable Max only All transformation datatypes except binary datatype. SetMinVariable Min only All transformation datatypes except binary datatype. SetCountVariable Count only Integer and small integer datatypes only. SetMaxVariable. Sets the variable to the maximum value of a group of values. It ignores rows marked for update, delete, or reject. SetMinVariable. Sets the variable to the minimum value of a group of values. It ignores rows marked for update, delete, or reject. SetCountVariable. Increments the variable value by one. In other words, it adds one to the variable value when a row is marked for insertion, and subtracts one when the row is marked for deletion. It ignores rows marked for update or reject. SetVariable. Sets the variable to the configured value. At the end of a session, it compares the final current value of the variable to the start value of the variable. Based on the aggregate type of the variable, it saves a final value to the repository. Cannot use variable functions in the Rank or Aggregator transformation。 Mapping parameter and variable values in mapplets must be preceded by the mapplet name in the parameter file, as follows: mappletname.parameter=value mappletname.variable=value 下面情况发生事不保存变量的修改值： SESSION失败/SESSION被设置为测试LOAD/是DEBUG SESSION/处于DEBUG模式下并且被设置为抛弃SESSION的输出。 实验： 1。建立一个变量Count 设置如下：integer型，Count类 2.在MAPPING中的F（X）组件中使用它： 用固有的函数对变量的值进行控制。 如果其它输出端口想使用该变量的当前值，可以变