nerdexam
Oracle

1Z0-456 · Question #33

Your company has developed Oracle Fusion Territory Management and ask the administrator to enable the dimensions in the territory definition by using data warehousing. Select the correct-sequence of…

The correct answer is B. 4, 2, 1, 3. In the Data Warehouse option, the data warehouse Extract-Transform-Load (ETL) logic extracts transaction and dimension data from Oracle Fusion Applications into the data warehouse first(4). The data warehouse stores dimensions and metrics data. Metrics data is based on…

Territory Management

Question

Your company has developed Oracle Fusion Territory Management and ask the administrator to enable the dimensions in the territory definition by using data warehousing. Select the correct-sequence of activities. 1. Populate the visibility settings in data warehouse by running ETL. 2. Identify the dimension members to be made visible for territory definition in Territory management. 3. Synchronize the territory management stage environment with the data source. 4. Populate the data warehouse with dimension members and transactional data.

Options

  • A2, 3, 1, 4
  • B4, 2, 1, 3
  • C2, 1, 4, 3
  • D3, 2, 1, 4

How the community answered

(58 responses)
  • A
    7% (4)
  • B
    76% (44)
  • C
    14% (8)
  • D
    3% (2)

Explanation

In the Data Warehouse option, the data warehouse Extract-Transform-Load (ETL) logic extracts transaction and dimension data from Oracle Fusion Applications into the data warehouse first(4). The data warehouse stores dimensions and metrics data. Metrics data is based on transactioninformation. Territory Management contains only a subset of the dimensions stored in data warehouse(2). This figure shows the use of ETL to load data from Fusion Applications to the data warehouse, and RPD to provide data to the cube and to Territory Management. ETL also loads the settings for visible and invisible dimension members from Territory Management to the data e_02_10104843.png

Topics

#data warehouse#ETL#territory dimensions#dimension visibility

Community Discussion

No community discussion yet for this question.

Full 1Z0-456 Practice