Skip to Content
0
Former Member
Mar 10, 2007 at 11:42 AM

ODS to CUBE Loading

15 Views

we have a requirement to load data from three ODS objects into one Infocube. Same key for all 3 ODS objects( Student Number as a keyfield) but data is comming from three different sources. I loaded upto 3 ODS objects is fine, problem is to load into Cube as a single record with student number. I am getting 3 records with the same Student number in the cube. with same student number from 3 ODS's are populated as 3 different records in the cube.

Example(papulating now as):

Stud. no-- -Marks -- -Fee --


Exempt.code...... ...

01--


794
0
--


0 ............ from ODS1

01--


0
200
--


0 ............ from ODS2

01--


0
0
--


001 ............ from ODS3

But desired format in the cube is:

01--


794
200
--


001 ............ as a one record

Could you suggest me on it.

I will assign points

Thanks,

Kaveri