MAPPING REQUIRED

[Former Member]

Hi

follwing condition is my mapping

can any one suggest to me can I do this with message mapping or

can i write user defined function.

If it is message mapping give me hint.

If Cust->Territory_District->Dist_oper_area_cd is between 700 and 720

Map the following to the staging table

cust_territory_district->dist_oper_area_cd to DRMO_div_mgr_cd

cust_territory_district->terr_gauge_dist_cd to Field_support_cd

cust_territory_district->cust_terr_eff_dt to DRMO_edate

cust_territory_district->cust_terr_can_dt to DRMO_cdate

cust_status_class->history_cust_stat to DRMO_history_cust_stat

cust_status_class->history_cust_class to DRMO_history_cust_class

cust_status_class->history_eff_date to DRMO_history_eff_date

cust_status_class->history_can_date to DRMO_history_can_date

Else

Map the following to the staging table

cust_territory_district->dist_oper_area_cd to dist_oper_area_cd

cust_territory_district->terr_gauge_dist_cd to terr_gauge_dist_cd

cust_territory_district->cust_terr_eff_dt to cust_terr_eff_dt

cust_territory_district->cust_terr_can_dt to cust_terr_can_dt

cust_status_class->history_cust_stat to history_cust_stat

cust_status_class->history_cust_class to history_cust_class

cust_status_class->history_eff_date to history_eff_date

cust_status_class->history_can_date to history_can_date

thanks&regards

venkat.

[Former Member]

For this condition, you can use the Less than and greater than standard fuction with and . it will work fine

<b>If Cust->Territory_District->Dist_oper_area_cd > 700 and

If Cust->Territory_District->Dist_oper_area_cd < 720</b>

<b>If Cust->Territory_District->Dist_oper_area_cd is between 700 and 720</b>

Both meaning are same now. so first one can be implemented using the Graphical mapping.

Warm Regards,

Vijay

[Former Member]

vaibhav,

even if the node is the parent u need to map in every field of the target unless he has 2 parent in the target strucuture for each of the two sets (on set for 700 bt 720 and another structure for rest)

[Former Member]

dat is presumed buddy that DRMO_div_mgr_cd and dist_oper_area_cd wud also had been parent nodes. Since that is not the case...we have to put the condition in each field.

Vaibhav

[Former Member]

u can use graphical message mapping in this

if the node 'cust_territory_district->dist_oper_area_cd' wud have been a parent node and the others following it wud have been child nodes then u only had to put the IF-ELSE condition on the parent node but since this is not the case so u will have to put the condition 'If Cust->Territory_District->Dist_oper_area_cd is between 700 and 720' into every field

Vaibhav

[former_member192892]

Venky cn u provide the source and target structures pl

Thanks