OGG -FILTER 引數過濾

huzhichengforce發表於2014-06-26
Filter
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);                                                                                                

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26764973/viewspace-1194993/，如需轉載，請註明出處，否則將追究法律責任。

相關文章