Versions Compared

Old Version 14

changes.mady.by.user Cortlandt _

Saved on

compared with

New Version 15

changes.mady.by.user Cortlandt _

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

User guide page for Source Object zData Warehouse. The zData Warehouse Source Object is a specialized data source managed by ETL+ serving two primary purposes. First to lookup and retrieve data in static reference tables such as the ETL+ Time Series tables provided by DataSelf. Second in order to allow re-importing data from existing target tables in the data warehouse for further transformations.

...

zData Warehouse and zData Warehouse lists the (Reimports) facilitate access to tables in the data warehouse as shown in the Target Objects panel. This allows you to create SQL queries modifying or combining existing Data Warehouse tables into a new target, data warehouse table. . SQL in the ETL+ Extract SQL Statement Panel can modify or combine existing data warehouse tables to create new target tables.
For tutorials see Using the zData Warehouse, Introduction and Navigation (Training)

Panel
bgColor#FFFAE6

The Properties page is not active for the zData Warehouse Source Object . becausezData Warehouse is a special data source controlled by ETL+

Re-Import

Reimporting refers to the process of extracting data from a data warehouse table after it has already been extracted, transformed, and loaded into that data warehouse table (target table).

Reimporting takes data already in the data warehouse and perform additional data manipulation on it.
See also Using the zData Warehouse

...

. For more see zData Warehouse Properties below.

Anchor
isMissingRequiredParameterstrue
zData Warehouse Properties

  • By default, do NOT change the data warehouse properties.Contact DataSelf if you need to change them and are unsure how to do it.

  • The properties for zData Warehouse are available via Settings > Data Warehouse.

Re-Import & zData Warehouse (Reimports)

Reimporting takes data already in the data warehouse and performs additional data manipulation on it.

For ETL+ reimporting refers to the process of extracting data from a data warehouse table (zData Warehouse) after it has already been extracted, transformed, and loading/importing that data back into the warehouse table (zData Warehouse (Reimport) )
See also zz_LoadOnce_Delete populates zData Warehouse (Reimports),

Related Pages

...