Why would you use a complex fact table instead of a simple fact table? Note: There are 3 correct answers to this question.
Consider the following scenario: EOP headcount has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. SOP headcount has Age and EEO Job Category dimensions turned on. Average headcount has Gender and Future Leader dimensions turned on. Hires has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. Terminations has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. You are required to perform the following task: Turn on Age, Disability, EEO Job Category, Employment Level, Employment Status and Gender dimensions on for EOP Headcount, SOP Headcount, and Average Headcount. How would you complete this task? Note: There are 2 correct answers to this question.
When using the Build Fact Data and Cube Command, the initial load fails with the following message in the log: Error: System.ArgumentException: Item has already been added. Key in dictionary: '[location].[location].[level1_che_zznostateprovince_geneva]' Key being added: '[location].[location].[level1_che_zznostateprovince_geneva]' at System.Collections.SortedList.Add(Object key, Object value) at System.Collections.SortedList.SyncSortedList.Add(Object key, Object value) at Hrml.DataObjects.HrmlOrgCubeDimensionTree.AddTreeNode(String path, String parentPath, Int32 depth, String caption) in. How do you fix the error?
Some dimension hierarchies in the Dimension Editor tool are greyed out, which prevents you from remapping codes located in the Unmapped node. Why are the hierarches greyed out?
Which of the following functions are managed in the WFA on HANA Data Factory tool? Note: There are 3 correct answers to this question.