Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm not that used to the star data model yet and kindly ask for your advice on the following matter:
Right now I think a link table would be the best option. But how would such a table look like exactly? And what would I do with the User ID dimension?
Thank you for your help!
David
Hope this screen is enough. The question is how to change Syn 1 Table to Link table. Create Link table with fields DocumentNo, CustomerKey, Currency Code, Salesperson Code- to link to tables (Detailed_CLE and SalesInvoiceHeader) and then link to SalesInvoiceLine? Or create link table connecting all three tables by DocumentNo field?