cancel
Showing results for 
Search instead for 
Did you mean: 

Linking transaction and Master data

Former Member
0 Kudos
53

Hi,

I have my transaction data coming from three sources( three different transaction data from three different sources) The key for the transaction data is A,B,C. One of my dimensions has A,B,C,D as keys.This dimension is associated with all the transaction data. How do i link it to the transaction data so that i dont get multiple master data entries for a given transaction record.

It is not possible to provide the KEY D in transaction data. Is there a way out?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You'll need to write an update routine to check for any duplicate records coming in for the Key D and then either filter that out or assign whatever value you want.

Cheers,

Kedar

Former Member
0 Kudos

Hi Ravi,

I think you can create a routine to derive the key D if you know how to derive it. Hope it helps.

Thanks and Regards

Subray Hegde