on 09-29-2010 9:17 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
u can go for UDF.
Chk this:
/people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.