Right-click and select Snapshot, then New from the pop-up menu.įrom the Design menu, select Snapshot, then New.
You can optionally add the dimensions, source tables, and so forth automatically. You do not need to select required or child objects, because the wizard does that for you.įor example, if you select a collection containing two cubes, then both the cubes are included in the snapshot. In the Design Center Project Explorer, select all the components you want to include in the snapshot. To open the Create Snapshot wizard and create a snapshot: Snapshots are also used by Warehouse Builder to support the recycle bin, providing the information needed to restore a deleted metadata object. With the knowledge gained by the comparison, you might import the metadata at a lower level of detail to avoid overwriting the definition of related metadata objects. For example, you can use snapshots to determine the impact an MDL metadata import will have on the current metadata repository. When used with other Warehouse Builder facilities, such as MDL metadata imports and impact analyses, snapshots can help you manage your metadata. They can also use signature snapshots to track the changes made to a particular component. Designers can create full snapshots of a particular component under development so that, if necessary, they can restore the component to its previous state. Managers can use full snapshots to perform large-scale actions, such as deploying a warehouse or restoring a warehouse to a previous point in history. Snapshots can be useful to both warehouse managers and designers. You can, however, export snapshots to disk files. Snapshots are stored in the database, in contrast to Metadata Loader exports, which are stored as separate disk files. Signature snapshots provide historical records for comparison.
Warehouse Builder supports two types of snapshots:įull snapshots provide backup and restore functionality. While an object can only have one current definition in the repository, it can have multiple snapshots that describe it at various points in time.
Let's see this in action: try(ResultSet columns = databaseMetaData.A snapshot contains all the information about its objects and the relationships for the object. We can also extract the columns of a particular table using the same DatabaseMetaData object.
0 kommentar(er)
