I have two master data objects, which I have to populate the latest record
I have two master data objects, which I have to populate the latest record into another master data object.
For Example :
Say'X' is one master data object and a,b,c,d,e,f are key fields in 'X' from which b is the data field, another master data object name is 'Y' and a is the key field and e is an another attribute in 'Y'. I need to pupulate the data for 'e' in 'Y' with a look up in 'X' with keyfield as 'a' for latest 'b' value "which is a date field in 'X' ".
I have written a start routine in transer rules of 'Y' and trying to load 200K records which is taking too long without dumps. If the same is being done for 1000 records it is taking in 20 Secs.
I want your help and suggetions.
Thanks in Advance.