Data Sources & Transformation Rules

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)