We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
ソース表から
For example, when you load data from a source table into a dimension, the higher levels within a dimension may be duplicated in the source.
This section describes the creation of a basic PL/SQL mapping that loads data from a source table to a target table. The purpose of this example is to illustrate the use of mappings and help you understand the objective achieved by creating mappings. Since the example is very basic, it does not perform any transformation o.n the source data. However, in a typical data warehousing environment, transformations are an integral part of mappings.
For example, when you load data from a source table into a dimension, the higher levels within a dimension may be duplicated in the source. Figure 18-6 displays a mapping that uses the Deduplicator operator to remove duplicate values in the source while loading data into the PRODUCTS dimension. The source table contains duplicate values for category ID because more than one products may belong to the same Deduplicator operator removes these duplicates and loads distinct values of category ID into the PRODUCTS dimension.
For example, you create a mapping that loads the Products Type 2 SCD. The leaf level of this Type 2 SCD, Product, is loaded from a source table. The Dimension operator has the following properties
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.