Using FILTER
Use FILTER to select or exclude records based on a numeric value. A filter expression can use
conditional operators, Oracle GoldenGatecolumn-conversion functions, or both
filter 参数基于数值来选择或者提出数据!!!-----最重要
Separate all FILTERcomponents with commas. A FILTERclause can include the following:
● Numbers
● Columns that contain numbers
● Functions that return numbers
● Arithmetic operators:
+ (plus)
- (minus)
* (multiply)
/ (divide)
\ (remainder)
● Comparison operators:
> (greater than)
>= (greater than or equal)
< (less than)
<= (less than or equal)
= (equal)
<> (not equal)
Results derived from comparisons can be zero (indicating FALSE) or non-zero (indicating
TRUE).
● Parentheses (for grouping results in the expression)
● Conjunction operators: AND, OR
FILTER ((PRODUCT_PRICE*PRODUCT_AMOUNT)>10000))
FILTER (@STRFIND(NAME, "JOE") > 0) @STRFIND--字符函数
意思是选择name中包含JOE的记录
++++++++++++++++++++++++++++++++++++++++
在做实验的时候
配置好抽取进程,复制进程启动起来并没有报错。
但是在insert 的时候复制进程中断abanded 数据复制失败 原来是filter 出错
改过filter 参数后启动复制进程,进程启动数据自动过滤后成功复制进目标表。
map gg.ehr_healthrecord,target regg.ehr_healthrecord FILTER (@STRFIND(MANADOCTORID,"hew") >0);
Use FILTER to select or exclude records based on a numeric value. A filter expression can use
conditional operators, Oracle GoldenGatecolumn-conversion functions, or both
filter 参数基于数值来选择或者提出数据!!!-----最重要
Separate all FILTERcomponents with commas. A FILTERclause can include the following:
● Numbers
● Columns that contain numbers
● Functions that return numbers
● Arithmetic operators:
+ (plus)
- (minus)
* (multiply)
/ (divide)
\ (remainder)
● Comparison operators:
> (greater than)
>= (greater than or equal)
< (less than)
<= (less than or equal)
= (equal)
<> (not equal)
Results derived from comparisons can be zero (indicating FALSE) or non-zero (indicating
TRUE).
● Parentheses (for grouping results in the expression)
● Conjunction operators: AND, OR
FILTER ((PRODUCT_PRICE*PRODUCT_AMOUNT)>10000))
FILTER (@STRFIND(NAME, "JOE") > 0) @STRFIND--字符函数
意思是选择name中包含JOE的记录
++++++++++++++++++++++++++++++++++++++++
在做实验的时候
配置好抽取进程,复制进程启动起来并没有报错。
但是在insert 的时候复制进程中断abanded 数据复制失败 原来是filter 出错
改过filter 参数后启动复制进程,进程启动数据自动过滤后成功复制进目标表。
map gg.ehr_healthrecord,target regg.ehr_healthrecord FILTER (@STRFIND(MANADOCTORID,"hew") >0);
![](http://img.blog.itpub.net/blog/attachment/201406/26/26764973_1403773742MMRr.jpg?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1194993/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764973/viewspace-1194993/