Forum Discussion

NILU090's avatar
NILU090
Icon for Helper II rankHelper II
3 years ago

many to many relationship problem

Hi Team, Needed solution from long back, stuck on this point. I have 2 tables. both has multiple ID. Table (right side) contains ID mulitple time as more than 2 person can be a part of 1 single act...
Need Help
darkinvader_'s avatar
darkinvader_
Icon for Resolver I rankResolver I
3 years ago

Hi NILU090 ,

I would suggest an easy asnwer which is to create another dim table which contains distinct ID', but it would cost you a peforance setback.

 

Or else you can reffer this video whcih might solve your problem.
YouTube Video 

 

Regards

darkinvader