Mapping and Transformation

Hi Team,

need to

Requirement1:
===========

Replication data filtering -

Source
======
Schema : A
Table  : xyz
column : C1
Type   : cust

I only need to replicat data from source to traget iff -> A.xyz.C1=cust

Requirement2:
===========

Database traversals:
From table.column                   To table.column
A.ALIAS_VALUE.id                 A.ALIAS_ASSOCIATION.id_alias_value
A.ALIAS_TYPE.id                    A.ALIAS_ASSOCIATION.id_alias_type
A.OBJECT_TYPE.id                 A.ALIAS_ASSOCIATION.id_object_type

Please let me know how to do mapping in extract / pump.

Thank you

GKris