How to create a data load procedure in Oracle?

Question

Oracle

There are 2 laboratory databases. OLAP
No. 3-4
Tasks 1. Creation of data

acquisition procedures.
1) Independently pay no less than 3 dzherel vіdkritih danikh.

For example - Register
of administrative-territorial structure https ://data.gov.ua/dataset/a2d6c060-e7e6-4471-ac6... 308f-42d7-895... Plan for the support measure of providing primary health care https://data.gov.ua/dataset/2a2502f0-19f7-4552-9b94-3b0db5 ... 2) Design a Stage Zone model for ETL processes.

3) Design the model of the main collection after the type after the type of "zirka" [4, st360] or "snіzhinka" . [4, st361]

4) Create an ETL to:
- Get data to the Stage zone

- Create a set of procedures/functions to convert and get data to the main repository. (Above the problem of creating ETL programs). Transfer the possibility of investing in changing and supplementary data.

5) Take the data to the main collection of the data.

Vmogi to zvіtu computer practicum

Zvіtu to computer practicum vykonuєtsya at Microsoft Word that is guilty of vengeance of the offensive division: Vіdomostі

pro vykonavtsya
Text of functions / procedures or configuring ETL zasobіv.
Stage models of the zone of the main site

No. 5

Task for preparation before the computer

workshop

Task 1. Create a DataSource

Create a DataSource to a database of data sources in 3-4 computer practicum.

Task 2. Create an AdHocView

Create an AdHocView with a cross-light view. Vykoristati not less than 3 vimіrіv, including "hour".

Task 3. Create a DashBoard

Create a DashBoard with 4 stars

- delete the stars in step 2.

- zvіt z pie chart be some fact for the rest of the river

- zvіt z line diagram be some fact by month.

- about the top 5.

Ob'yazkovo create zv'zanі zvіti and zvіti with parameters

Vmogi to the star of the computer workshop

Zvіt to the computer workshop vykonuetsya at Microsoft Word and is guilty of vengeance on the offensive: Screenshots of creations DataSource, AdHocView

. Screenshots of DashBoard I don’t understand how to do them, please describe how and what to do and if possible, throw a link to a guide on this topic