Examples with "master table's data" and their translation in Japans
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.
A materialized view log is a schema object that records changes to a master table's data so that a materialized view defined on the master table can be refreshed incrementally. Each materialized view log is associated with a single master table. The materialized view log resides in the same database and schema as its master table.
A materialized view provides access to table data by storing query results in a separate schema object. Unlike an ordinary view, which does not take up storage space or contain data, a materialized view contains the rows from a query of one or more base tables or views. A materialized view log is a schema object that records changes to a master table's data, so that a materialized view defined on the master table can be refreshed incrementally. SQL Access Advisor recommends how to optimize materialized views so that they can be rapidly refreshed and make use of the query rewrite learn more about materialized views, see Oracle Database Concepts.
Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. A materialized view can be partitioned. You can define a materialized view on a partitioned table and one or more indexes on the materialized view. A materialized view log is a schema object that records changes to a master table's data so that a materialized view defined on the master table can be refreshed incrementally. Each materialized view log is associated with a single master table. The materialized view log resides in the same database and schema as its master table.
Typically, this option should only be enabled if you plan to have aggregate materialized views based on the master table in a data warehousing environment.
When enabled, this box specifies that a sequence value providing additional ordering information should be recorded in the materialized view log. If you plan to have aggregate materialized views, then sequence numbers are necessary to support fast refresh after some update scenarios. Typically, this option should only be enabled if you plan to have aggregate materialized views based on the master table in a data warehousing environment. Disable this option for a typical replication environment.
After the initial loading of the master and detail tables, you can use the loaded sequence values to further transform, update, or merge master table data with detail table example, if your master records have a column that acts as a unique identifier, such as an Employee ID, and you want to use it as the key to join master and detail rows (instead of the sequence field you added for that purpose), you can update the detail tables to use this unique column. You can then drop the sequence column you created for the initial load. Operators such as the Aggregator, Filter, or Match and Merge operator can help you with these subsequent transformations.
You can query multiple SAP BW data sources within a report. SAP BW data sources can include InfoProviders, which provide unified access to all types of SAP BW objects. These objects include InfoCubes, ODS objects, Master Data Tables, InfoSets, and remote InfoCubes.
A master table's materialized view log keeps track of fast refresh data for all corresponding simple materialized views. When a server performs a fast refresh for a simple materialized view, it uses the data in its master table's materialized view log to refresh the materialized view very efficiently. The Replication Management tool has many features that help you create and manage materialized view logs.
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.