Views are flexible way to get up-to-date data without the hassle of execution. However, the time it takes to read from a complex view can be a lot longer than a table with a comparable amount of data. For cases like this, the Persist View option in TimeXtender Data Integration presents a simple way to essentially turn a view into a table.

When you enable the option to persist a view, the system will create a table with the same name as the view and rename the view by post-fixing "_p". All other tables and views that get data from the view will now do so from the table behind the scenes. However, when you want updated data, you need to execute the view.

Enabling or disabling the Persist View option

To enable or disable the persist view option

• Right-click the view, and under Advanced, click Persist View

Manually creating a table from a view

A view can also be manually created from a table by dragging the view onto the table node of a data area. Make sure to right-click on the view and select Read View Fields or Synchronize View Fields before dragging the view onto the table node. Also right-click on the Map Custom View Fields and map the fields in order to use visualization option such as Data Lineage.