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.