Hi
we have two types of data sets one is source data and one is hierarchy data with market and business
source data contains :
market name
business name
aggregate
data1
data2
hierarchy data contains :
market key
market name
business key
business name
Now the output should not have any duplicates
for example let us consider a market
North America
In source data it has
Aggregate,Market name ,data1
Region,North america, 54
Sub Region,North america, 60
Zone,North america, 66
In hierarchy data it has
market name ,market key
North america , M_NAM
North america , M_NAMS
North america , M_NAMZ
Now I should need data with out duplicates while selecting market how should I join data
Can you please help me out with this
Thanks in advance
