data filtering and transformation
edited May 19, 2014 11:13AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi Team,
Need to replicat 3 tables from source to target having same table structure , using some data filtering and transformation.
Source Details:
================
OS : Sun Solaris 5.10
DB Version: 11.2
GG Version: 10.4
01. I have doubt like , can I achieve data filtering and transformation in source side or Target side? which is preferred?
02. Need to replicat 3 tables from source to target having same table structure , using some data filtering and transformation logic below.
Extract:
========
TABLE GDB.ALIAS_VALUE;
Data filtering and transformation logic:
========================================
where ALIAS_TYPE.TYPE='CUSTOMER_DEFINED_ASSET_TICKET_ALIAS'
and OBJECT_TYPE.NAME='ASSET'
and ALIAS_VALUE.id = ALIAS_ASSOCIATION.id_alias_value
0