Skip to Content
avatar image
Former Member

Need Mapping Logic

I have one mapping requirment as follows.

From Source Structure :

There are Fields Payment Type , Agg Rev Share & carrierREV sHARE.

Here i need to write logic for :

If Payment Type = CC , Agg Rev share = 0 & carrierREV sHARE = 0

then pass the value to target else i need to throw expection when .Agg Rev share & carrierREV sHARE values are greater than 0.

Please guide me friends

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 29, 2010 at 10:12 AM

    Hi renu,

    You need to use ifThenElse funtcion twice.

    1st ifThenElse:

    Concat Agg Rev Share & carrierREV sHARE and check whether they are greater than constant 00.

    Output of the greater will be given to the if part of function.

    For Then part, you have to use 2nd ifThenElse and for else part keep the UDF you have for exception.

    2ndifThenElse:

    First compare Payment Type against constant CC (use equalS function) and output of this is given to if part of ifThenElse.

    Then part will be the actual value of source you want to give to target and else part will be the UDF of exception.

    -Supriya.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 29, 2010 at 08:47 AM

    Hi,

    u can go for UDF.

    Chk this:

    /people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping

    Thanks

    Amit

    Add comment
    10|10000 characters needed characters exceeded