Need Suggestions

Database
MBR
Enthusiast

Need Suggestions

first of all thanks to seeing my post

i am working on EDW

we have lookups for to maintaining the keys

now i am getting the issue here when i am trying to load the data from staging to target ,here in staging we have duplicated data but in lookup we are having unique data

when i am joining to lookup with Staging i am getting more records than actual record count because of product join

though i m using INNER JOIN its doing product join because of lookups having unique data and staging having same number 10 times this is not a key column in staging.

can any one give suggestions how to avoid this.

Thanks in advance.

Regards

MBR