DSV Spec Exercise Steps

1. From an editor such as Notepad, Notepad++, or Visual Studio's XML editor, create a new XML document called INTERACTIONRESPONSE_EXT.DSVTable.xml.

2. Paste the following skeletal markup into the file:

   <DSVDeploymentInfo>
     <DSVTableName>TABLE</DSVTableName>
     <DSVSQL>
       select
         e.[COLUMN],
       from BBDW.[VIEW OF TABLE] e
     </DSVSQL>
     <DSVTableColumns>    
       <DSVTableColumn>
         <ColumnName>COLUMN</ColumnName>
         <DataType>DATATYPE</DataType>
         <Key>TRUE/FALSE</Key>
       </DSVTableColumn>
     </DSVTableColumns>
   </DSVDeploymentInfo>

3. Replace TABLE in <DSVTableName>TABLE</DSVTableName> with FACT_INTERACTIONRESPONSE_EXT.

4. In the Transact-SQL code contained within <DSVSQL></DSVSQL>, add a SELECT statement for the rows in [BBDW].[v_FACT_INTERACTIONRESPONSE_EXT].

   You can base this SELECT statement on the CREATE TABLE statement in the database revision extension.

   SELECT is a Data Manipulation Language (DML) statement that retrieves rows from a database. For more information about SELECT statements, see Microsoft's MSDN article at SELECT (Transact-SQL).

   select
     e.[INTERACTIONRESPONSEFACTID],
     e.[INTERACTIONRESPONSESYSTEMID],
     e.[INTERACTIONFACTID],
     e.[RESPONSEDIMID],
     e.[INTERACTIONRESPONSEDATEDIMID],
     e.[INTERACTIONRESPONSEDATE],
     e.[ISINCLUDED],
     e.[ETLCONTROLID],
     e.[SOURCEDIMID]
    from [BBDW].[v_FACT_INTERACTIONRESPONSE_EXT]

5. For each column in the SELECT statement, create a node in <DSVTableColumns></DSVTableColumns>.

6. Here are some blank nodes:

    <DSVTableColumns>    
       <DSVTableColumn>
         <ColumnName></ColumnName>
         <DataType></DataType>
         <Key></Key>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName></ColumnName>
         <DataType></DataType>
         <DataSize></DataSize>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName></ColumnName>
         <DataType></DataType>
         <DataSize></DataSize>
       </DSVTableColumn>
       <DSVTableColumn>
   </DSVTableColumns>

   Here is the filled in set:

    <DSVTableColumns>    
       <DSVTableColumn>
         <ColumnName>INTERACTIONRESPONSEFACTID</ColumnName>
         <DataType>Int32</DataType>
         <Key></Key>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>INTERACTIONRESPONSESYSTEMID</ColumnName>
         <DataType>Guid</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>INTERACTIONFACTID</ColumnName>
         <DataType>Int32</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>RESPONSEDIMID</ColumnName>
         <DataType>Int32</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>INTERACTIONRESPONSEDATEDIMID</ColumnName>
         <DataType>Int32</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>INTERACTIONRESPONSEDATE</ColumnName>
         <DataType>DateTime</DataType>
       </DSVTableColumn>
   	    <DSVTableColumn>
         <ColumnName>ISINCLUDED</ColumnName>
         <DataType>Boolean</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>ETLCONTROLID</ColumnName>
         <DataType>Int32</DataType>
       </DSVTableColumn>
       <DSVTableColumn>
         <ColumnName>SOURCEDIMID</ColumnName>
         <DataType>Int32</DataType>
       </DSVTableColumn>
   </DSVTableColumns>  

7. Save the spec.