on 05-15-2009 11:23 PM
Hi,
my source structure is like this:
<Category CategoryType="">
<ProductQuantity>
</ProductQuantity>
<DateTimeInformation>
<DateTime DateTimeQualifier=""/>
<DateTimeRange>
<FromDateTime/>
<ToDateTime/>
</DateTimeRange>
</DateTimeInformation>
</Category>
<DateTime><DateTimeRange> this two tags, everytime we can have only one of them.
my target structure is:
<Category CategoryType="">
<ProductQuantity>
</ProductQuantity>
<DateTimeInformation>
<Date/>
</DateTimeInformation>
</Category>
i have two mapping rules, one is if <DateTimeRange> occurs in the source, then split the range into different dates(every Monday), like if range is from 1th june to 19th june, then three dates, 1th june, 8th june, 15th june should be put into the target strucuture in three records.
the second mapping is if AvailabilityClassificationType and Date is exactly the same in source, we add the quantity measurement and put it into one record in target..
can i solve this in graphical mapping? or i need to use UDF?
Thanks a lot
Jessica
Hi,
You will have to create a User Defined function. That is the only answer.
However what you are trying to achieve should really be in the application logic of the sending or receiving system.
My advice is to avoid application logic in Integration and keep the integration clean.
regards,
Advait
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 do this using graphical mapping only...no need to use UDF.
Use date functions to spilt date range and node functions to create number of nodes at target side.
regards,
Manisha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have to use udf.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.