Font size
WorksheetsData Sources & Transformation Rules
Total questions: 12
Worksheet time: 8mins
Data Sources are based on the selection of the? (pick 2)
Account
Cube Name
Entity Name
Scenario Type
For Fixed Files, the Fields are mapped by designated ___ and based on the number of ___ within a source file
Row Ranges
length
Column Ranges
number of characters
Delimited Files Contain data that’s separated by a special character (comma, semi-colon, or another character). True or False?
True
False
When working with Data Sources, what will the Data Type Filed within the Account Dimension be set to?
(a)
What POV must be set before loading to stage?
Workflow
Cube
Global
What 4 tasks must be completed before importing data?
Assign Data Sources and Transformation Rules to an Import Workflow Profile
Build a Data Source in OS
Build Transformation Rule Groups for each enabled Dimension & assign Transformation Rule Profile
Create Cube Views
Set the Global POV if it has not yet been set
Transformation Rules are created to?
Map the source intersections to target intersection upon data export
Clear data
Link data
Map the source intersections to target intersection upon data import
Does the Attribute Value Dimension load data into the cube ?
True
False
Which tab corresponds to where you can enable and disable the Dimensions that will be populated through the import of source system data?
Data Access
Integration tab
Cube References tab
Cube Properties tab
Once Transformation Rule Profiles are created, they are then assigned to the
(a)
The One-To-One Mapping Transformation Rule type allow for ___source Dimension Member to be ampped or transformed to one target dimension member.
four
one
three
two
when you update your data source, you always have to ____your file
refresh
delete
reload
export
