Hi All,
I got Two ODSs.I want to load data from these two ODS into a single cube. Cube consists of fields from both ODS. I want to load the data from ODS1. while loading the data i need to get the corresponding fields from ODS2 based on a condition.
e.g.
My cube got fields a,b,c,d,e,f,g.( f,g are key figures).
My ODS1 got a,b,c,f (f is a key figure).
MY ODS2 got d,e,g (g is a key figure).
My condition is if ODS1-a = ODS2-d, then my cube record should be a,b,c,d,e,f,g.
There r more than 1 field in ODS1 with equal value. For all these records i need the corresponding fileds from ODS2.
Can anyone suggest how to write routines for this?
It is a urgent Requirement.
Regards,
Ramana.