You are designing a data mart for the human resources (HR) department at your company. The data mart will contain employee information and employee transactions.
From a source system, you have a flat extract that has the following fields:
✑ EmployeeID
FirstName -
✑ LastName
✑ Recipient
✑ GrossAmount
✑ TransactionID
✑ GovernmentID
✑ NetAmountPaid
✑ TransactionDate
You need to design a star schema data model in an Azure Synapse Analytics dedicated SQL pool for the data mart.
Which two tables should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
avijitd
Highly Voted 3 years, 8 months agomoize
Most Recent 8 months, 2 weeks agoEmnCours
8 months, 2 weeks agomavdplas
8 months, 3 weeks agoellala
1 year, 10 months agohassexat
1 year, 11 months agokkk5566
1 year, 11 months agoSHENOOOO
2 years, 6 months agokl8585
2 years, 9 months agoDeeksha1234
3 years agoRemedios79
3 years, 1 month agohm358
3 years, 2 months agoSandipSingha
3 years, 3 months agotg2707
3 years, 3 months agoAditya0891
3 years, 2 months agogabrysr1997
3 years, 1 month agoEgocentric
3 years, 3 months agoNewTuanAnh
3 years, 4 months agoSebK
3 years, 4 months ago