Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mapping of Target Columns based on Source Column value

710478Jul 27 2009 — edited Aug 7 2009

Hi,

I have the following requirement in ODI..

Source: Oracle
Target: SQL Server 2005

I have an Interface that maps Source (Oracle) Table to Target (SQL Server) Table. It is almost "one to one" mapping but the Mapping while Updating record in Target should happen based on Source Column value.

Say for Eg: I have 4 columns as Src_ID, Src_Col_1, Src_Col_2, Src_Col_3 in Source and
Trg_ID, Trg_Col_1, Trg_Col_2, Trg_Col_3 in Target.

Insert : Insert would happen when ever there is no record for that ID in Target. This reqmt is anyway fulfilled by basic functionality of ODI itself.

Update: Update in Target is bit tricky for this reqmt. Say i get Values from Source as

Src_ID: 1001
Src_Col_1: 900
Src_Col_2: 0
Src_Col_3: 0

Reqmt: Update target columns only if the Value of the Source column is > Zero (0). i.e In this above scenario, ODI should update only Trg_Col_1 as it has vlaue>0.
It should not update Trg_Col_2 and Trg_Col_3.

Please suggest how we can achieve this reqmt...

Your response is appreciated..

Regards,
Anil

Edited by: user11338534 on Jul 27, 2009 12:59 PM

Edited by: user11338534 on Jul 28, 2009 9:35 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2009

Added on Jul 27 2009

#business-intelligence-applications, #data-integrator, #odi, #oracle, #server, #sql, #system-management-and-integration

9 comments

2,580 views