?

[xyz1]

.

[vinieme12]

Yes , a sample app will be helpful

[prma7799]

Share a sample qvw file.

[xyz1]

.

[xyz1]

.

[#6]

three synthetic keys is not a big issue, More synthetic keys will not effect your data. even if we take link tables that also same, So you no need to bother about the synthetic keys in your data model.

You can continue with reports without any fear.

[prma7799]

for this $Syn 1 = Team+Role

You have to write

left join

[xyz1]

.

[prma7799]

Can you please tell me in allocation tab what you have to do.

I mean which criteria basis you need join the tables

[prma7799 · Accepted solution]

PFA...