Page History

You can customize the DW queries on individual entities in the DW Query tab in the Entity Properties dialog. DW queries are used to populate a table from its direct source tables, for example populating a dimension from its stage table(s).
REPLACE WITH THIS IMAGE: Images/Entities/Entity DW Query Properties.png Image Added 
If a DW query was previously entered or generated it is shown in the query editor pane.
To generate a new DW query for the entity:

1. Select a Source set.
2. Optionally select a template to use from the drop-down list and then click Generate. If there is an existing DW query that is different from what is generated a differences window appears, enabling you to select the changes to be made. To accept the changes

...

1. click OK.

...

1. 
   Image Added

• To insert a stored query, click Insert stored SQL query REPLACE WITH THIS IMAGE: Images/Common_Icons/open_sql.png. Image Added. Refer to Inserting a Stored SQL Query for details.
• To store the DW query, click Store SQL query REPLACE WITH THIS IMAGE: Images/Common_Icons/saveicon.png Image Added. Refer to Storing SQL Queries for details.
• Click OK or Apply to save the DW query.
  

  Note
  title Note
  If you have made changes in

  the

  the Source Mappings

  tab

  tab before editing the query, you must apply those changes before the query generation detects them. A label is shown in the top right corner of

  the

  the Query

  tab

  tab in this scenario.

  REPLACE WITH THIS IMAGE: Images/Entities/Entity DW Query Properties_2.png

  Image Added