Skip to Content
1
Former Member
Aug 13, 2007 at 03:56 PM

Data load from DSO to cube

24 Views

Hi gurus

We have a typical problem, we have to combined 2 records into one when they reach to DSO.

One source is flat file and the other is R3. so few fields I am geting from flat file and few from R3 . They are creating one record when they loaded to DSO . Now I am getting one record in active data table but when I load the data to cube from that DSO ( Data is going from change log to cube ) to cube , I am getting 2 seperate records ( one which is loaded from flat file and one which is loaded from R3 ) in cube which I dont want. I want only one record in cube just like i have in my active data table in DSO.

I cant get the data from Active data table because I need delta load.

Would you please advise what can I do to get that one record in Cube?

Pl help