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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.