<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.0.1600.22" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="309.245" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="410.412" StatementText="SELECT&#xD;&#xA;  DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_TYPE&#xD;&#xA;,&#xD;&#xA;  CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END,&#xD;&#xA;  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end ,&#xD;&#xA;  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;,&#xD;&#xA;  sum(DTMPFO.dbo.DTMPFO_IMPRESSIONS.FG_RENEW),&#xD;&#xA;  PARTNER.CD_PARTNER&#xD;&#xA;,&#xD;&#xA;  PARTNER.LB_PARTNER&#xD;&#xA;FROM&#xD;&#xA;  CALENDAR RIGHT OUTER JOIN DTMPFO.dbo.DTMPFO_IMPRESSIONS ON (CALENDAR.LB_DAY=cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN POLICY ON (DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN PARTNER ON (POLICY.CD_PARTNER=PARTNER.CD_PARTNER)&#xD;&#xA;   LEFT OUTER JOIN POLICY_STATUS_ACTUAL ON (POLICY_STATUS_ACTUAL.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN POLICY_STATUS ON (POLICY_STATUS.CD_POLICY_STATUS=POLICY_STATUS_ACTUAL.CD_POLICY_STATUS)&#xD;&#xA;   LEFT OUTER JOIN SCHEDULE ON (SCHEDULE.CD_SCHEDULE=DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE)&#xD;&#xA;  &#xD;&#xA;WHERE&#xD;&#xA;  ( &#xD;&#xA;  DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_TYPE&#xD;&#xA;  IN  ('CN1', 'RN1', 'RN2', 'RN3')&#xD;&#xA;  AND  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;  IN  (SELECT&#xD;&#xA;  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY then POLICY.CD_SCHEDULE &#xD;&#xA;else SCHEDULE.CD_SCHEDULE&#xD;&#xA;end &#xD;&#xA;&#xD;&#xA;FROM&#xD;&#xA;  CALENDAR RIGHT OUTER JOIN DTMPFO.dbo.DTMPFO_IMPRESSIONS ON (CALENDAR.LB_DAY=cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;)&#xD;&#xA;   LEFT OUTER JOIN POLICY ON (DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_POLICY=POLICY.CD_POLICY)&#xD;&#xA;   LEFT OUTER JOIN SCHEDULE ON (SCHEDULE.CD_SCHEDULE=DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE)&#xD;&#xA;  &#xD;&#xA;WHERE&#xD;&#xA;  ( &#xD;&#xA;  (CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END  IN  ('47_CNA_A4', '47_RNA_A4', '47_RNB_A4')&#xD;&#xA;  OR   CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END  IN  ('47D_CNA_A4', '47D_RNA_A4', '47D_RNB_A4', '47V_CNA_A4', '47V_RNA_A4', '47V_RNB_A4')&#xD;&#xA;  AND  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end   NOT BETWEEN  '04/01/2010 00:0:0' AND '04/13/2010 00:0:0')&#xD;&#xA;  AND  DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_RENEW_THEO  BETWEEN  '2011-07-01' AND '2011-07-31'&#xD;&#xA;  AND  DTMPFO.dbo.DTMPFO_IMPRESSIONS.STATUS  IN  ('D', 'P')&#xD;&#xA;  )&#xD;&#xA;)&#xD;&#xA;  AND  POLICY_STATUS.CD_POLICY_STATUS  !=  'Z'&#xD;&#xA;  AND  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end   &gt;=  '2011-02-01'&#xD;&#xA;  AND  DTMPFO.dbo.DTMPFO_IMPRESSIONS.STATUS  IN  ('D', 'P')&#xD;&#xA;  )&#xD;&#xA;GROUP BY&#xD;&#xA;  DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_TYPE&#xD;&#xA;, &#xD;&#xA;  CASE &#xD;&#xA;WHEN &#xD;&#xA;DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME= '' then null&#xD;&#xA;ELSE upper(DTMPFO.dbo.DTMPFO_IMPRESSIONS.LETTER_NAME)&#xD;&#xA;END, &#xD;&#xA;  case&#xD;&#xA;when cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime) is null then cast(convert(varchar(10), DTMPFO.dbo.DTMPFO_IMPRESSIONS.DT_REQUEST, 112) as datetime)&#xD;&#xA;else cast(convert(varchar(10), CALENDAR.LB_DAY, 112) as datetime)&#xD;&#xA;end , &#xD;&#xA;  CASE &#xD;&#xA;when DTMPFO.dbo.DTMPFO_IMPRESSIONS.CD_SCHEDULE is null and DTMPFO.d" StatementType="SELECT" QueryHash="0xC85AB7DCF6B9CEC9" QueryPlanHash="0xE43D02C228BA0AB8">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan CachedPlanSize="368" CompileTime="253" CompileCPU="253" CompileMemory="3800">
            <MissingIndexes>
              <MissingIndexGroup Impact="39.82">
                <MissingIndex Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]">
                  <ColumnGroup Usage="INEQUALITY">
                    <Column Name="[STATUS]" ColumnId="10" />
                    <Column Name="[DT_RENEW_THEO]" ColumnId="25" />
                  </ColumnGroup>
                  <ColumnGroup Usage="INCLUDE">
                    <Column Name="[DT_REQUEST]" ColumnId="2" />
                    <Column Name="[CD_POLICY]" ColumnId="6" />
                    <Column Name="[CD_SCHEDULE]" ColumnId="7" />
                    <Column Name="[LETTER_NAME]" ColumnId="12" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
            </MissingIndexes>
            <RelOp AvgRowSize="130" EstimateCPU="0.0295037" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="309.245" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="410.412">
              <OutputList>
                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                <ColumnReference Column="Expr1034" />
                <ColumnReference Column="Expr1035" />
                <ColumnReference Column="Expr1036" />
                <ColumnReference Column="Expr1037" />
              </OutputList>
              <Parallelism>
                <RelOp AvgRowSize="130" EstimateCPU="0.000259217" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="309.245" LogicalOp="Filter" NodeId="1" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="410.382">
                  <OutputList>
                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                    <ColumnReference Column="Expr1034" />
                    <ColumnReference Column="Expr1035" />
                    <ColumnReference Column="Expr1036" />
                    <ColumnReference Column="Expr1037" />
                  </OutputList>
                  <Filter StartupExpression="false">
                    <RelOp AvgRowSize="130" EstimateCPU="0.000594039" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Compute Scalar" NodeId="2" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="410.382">
                      <OutputList>
                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                        <ColumnReference Column="Expr1034" />
                        <ColumnReference Column="Expr1035" />
                        <ColumnReference Column="Expr1036" />
                        <ColumnReference Column="Expr1037" />
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1037" />
                            <ScalarOperator ScalarString="CASE WHEN [Expr1084]=(0) THEN NULL ELSE [Expr1085] END">
                              <IF>
                                <Condition>
                                  <ScalarOperator>
                                    <Compare CompareOp="EQ">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Column="Expr1084" />
                                        </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                        <Const ConstValue="(0)" />
                                      </ScalarOperator>
                                    </Compare>
                                  </ScalarOperator>
                                </Condition>
                                <Then>
                                  <ScalarOperator>
                                    <Const ConstValue="NULL" />
                                  </ScalarOperator>
                                </Then>
                                <Else>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1085" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Else>
                              </IF>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp AvgRowSize="130" EstimateCPU="0.000594039" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Aggregate" NodeId="3" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="410.382">
                          <OutputList>
                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                            <ColumnReference Column="Expr1034" />
                            <ColumnReference Column="Expr1035" />
                            <ColumnReference Column="Expr1036" />
                            <ColumnReference Column="Expr1084" />
                            <ColumnReference Column="Expr1085" />
                          </OutputList>
                          <StreamAggregate>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1084" />
                                <ScalarOperator ScalarString="COUNT_BIG([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[FG_RENEW])">
                                  <Aggregate AggType="COUNT_BIG" Distinct="false">
                                    <ScalarOperator>
                                      <Identifier>
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </Aggregate>
                                </ScalarOperator>
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Column="Expr1085" />
                                <ScalarOperator ScalarString="SUM([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[FG_RENEW])">
                                  <Aggregate AggType="SUM" Distinct="false">
                                    <ScalarOperator>
                                      <Identifier>
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </Aggregate>
                                </ScalarOperator>
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                <ScalarOperator ScalarString="ANY([DWH].[dbo].[PARTNER].[LB_PARTNER])">
                                  <Aggregate AggType="ANY" Distinct="false">
                                    <ScalarOperator>
                                      <Identifier>
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </Aggregate>
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <GroupBy>
                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                              <ColumnReference Column="Expr1034" />
                              <ColumnReference Column="Expr1035" />
                              <ColumnReference Column="Expr1036" />
                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                            </GroupBy>
                            <RelOp AvgRowSize="130" EstimateCPU="0.00935684" EstimateIO="0.00281532" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Sort" NodeId="4" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="410.381">
                              <OutputList>
                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                <ColumnReference Column="Expr1034" />
                                <ColumnReference Column="Expr1035" />
                                <ColumnReference Column="Expr1036" />
                              </OutputList>
                              <MemoryFractions Input="0.000823812" Output="1" />
                              <Sort Distinct="false">
                                <OrderBy>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                  </OrderByColumn>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Column="Expr1034" />
                                  </OrderByColumn>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Column="Expr1035" />
                                  </OrderByColumn>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Column="Expr1036" />
                                  </OrderByColumn>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                  </OrderByColumn>
                                </OrderBy>
                                <RelOp AvgRowSize="130" EstimateCPU="0.0371364" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Repartition Streams" NodeId="5" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="410.369">
                                  <OutputList>
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                    <ColumnReference Column="Expr1034" />
                                    <ColumnReference Column="Expr1035" />
                                    <ColumnReference Column="Expr1036" />
                                  </OutputList>
                                  <Parallelism PartitioningType="Hash">
                                    <PartitionColumns>
                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                      <ColumnReference Column="Expr1034" />
                                      <ColumnReference Column="Expr1035" />
                                      <ColumnReference Column="Expr1036" />
                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                    </PartitionColumns>
                                    <RelOp AvgRowSize="130" EstimateCPU="5.40036E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Compute Scalar" NodeId="6" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="410.332">
                                      <OutputList>
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                        <ColumnReference Column="Expr1034" />
                                        <ColumnReference Column="Expr1035" />
                                        <ColumnReference Column="Expr1036" />
                                      </OutputList>
                                      <ComputeScalar>
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Column="Expr1035" />
                                            <ScalarOperator ScalarString="CASE WHEN [Expr1055] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END">
                                              <IF>
                                                <Condition>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="IS">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1055" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Condition>
                                                <Then>
                                                  <ScalarOperator>
                                                    <Convert DataType="datetime" Style="0" Implicit="false">
                                                      <ScalarOperator>
                                                        <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Convert>
                                                      </ScalarOperator>
                                                    </Convert>
                                                  </ScalarOperator>
                                                </Then>
                                                <Else>
                                                  <ScalarOperator>
                                                    <Convert DataType="datetime" Style="0" Implicit="false">
                                                      <ScalarOperator>
                                                        <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Convert>
                                                      </ScalarOperator>
                                                    </Convert>
                                                  </ScalarOperator>
                                                </Else>
                                              </IF>
                                            </ScalarOperator>
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Column="Expr1036" />
                                            <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END">
                                              <IF>
                                                <Condition>
                                                  <ScalarOperator>
                                                    <Logical Operation="AND">
                                                      <ScalarOperator>
                                                        <Compare CompareOp="IS">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="NULL" />
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Compare CompareOp="EQ">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                    </Logical>
                                                  </ScalarOperator>
                                                </Condition>
                                                <Then>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Then>
                                                <Else>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Else>
                                              </IF>
                                            </ScalarOperator>
                                          </DefinedValue>
                                        </DefinedValues>
                                        <RelOp AvgRowSize="163" EstimateCPU="1.92969" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2160.14" LogicalOp="Right Semi Join" NodeId="7" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="410.332">
                                          <OutputList>
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                            <ColumnReference Column="Expr1034" />
                                            <ColumnReference Column="Expr1055" />
                                          </OutputList>
                                          <MemoryFractions Input="0.00251062" Output="0.00345643" />
                                          <Hash>
                                            <DefinedValues />
                                            <HashKeysBuild>
                                              <ColumnReference Column="Expr1066" />
                                            </HashKeysBuild>
                                            <HashKeysProbe>
                                              <ColumnReference Column="Expr1067" />
                                            </HashKeysProbe>
                                            <ProbeResidual>
                                              <ScalarOperator ScalarString="[Expr1067]=[Expr1066]">
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Column="Expr1067" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Column="Expr1066" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </ProbeResidual>
                                            <RelOp AvgRowSize="11" EstimateCPU="0.0295317" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Bitmap Create" NodeId="8" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="192.22">
                                              <OutputList>
                                                <ColumnReference Column="Expr1066" />
                                              </OutputList>
                                              <Bitmap>
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Column="Bitmap1083" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <HashKeys>
                                                  <ColumnReference Column="Expr1066" />
                                                </HashKeys>
                                                <RelOp AvgRowSize="11" EstimateCPU="0.0295317" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Repartition Streams" NodeId="9" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="192.22">
                                                  <OutputList>
                                                    <ColumnReference Column="Expr1066" />
                                                  </OutputList>
                                                  <Parallelism PartitioningType="Hash">
                                                    <PartitionColumns>
                                                      <ColumnReference Column="Expr1066" />
                                                    </PartitionColumns>
                                                    <RelOp AvgRowSize="11" EstimateCPU="4.30548E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Compute Scalar" NodeId="10" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="192.191">
                                                      <OutputList>
                                                        <ColumnReference Column="Expr1066" />
                                                      </OutputList>
                                                      <ComputeScalar>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Column="Expr1066" />
                                                            <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END">
                                                              <IF>
                                                                <Condition>
                                                                  <ScalarOperator>
                                                                    <Logical Operation="AND">
                                                                      <ScalarOperator>
                                                                        <Compare CompareOp="IS">
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Const ConstValue="NULL" />
                                                                          </ScalarOperator>
                                                                        </Compare>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Compare CompareOp="EQ">
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                        </Compare>
                                                                      </ScalarOperator>
                                                                    </Logical>
                                                                  </ScalarOperator>
                                                                </Condition>
                                                                <Then>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                </Then>
                                                                <Else>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                </Else>
                                                              </IF>
                                                            </ScalarOperator>
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <RelOp AvgRowSize="27" EstimateCPU="0.00179969" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Left Outer Join" NodeId="11" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="192.191">
                                                          <OutputList>
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                          </OutputList>
                                                          <NestedLoops Optimized="false" WithUnorderedPrefetch="true">
                                                            <OuterReferences>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                              <ColumnReference Column="Expr1079" />
                                                            </OuterReferences>
                                                            <RelOp AvgRowSize="23" EstimateCPU="0.00179969" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Left Outer Join" NodeId="13" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="186.902">
                                                              <OutputList>
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                              </OutputList>
                                                              <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
                                                                <OuterReferences>
                                                                  <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                  <ColumnReference Column="Expr1078" />
                                                                </OuterReferences>
                                                                <RelOp AvgRowSize="15" EstimateCPU="0.104689" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1722.19" LogicalOp="Filter" NodeId="16" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="181.331">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                  </OutputList>
                                                                  <Filter StartupExpression="false">
                                                                    <RelOp AvgRowSize="73" EstimateCPU="0.00184311" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="73724.3" LogicalOp="Compute Scalar" NodeId="17" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="181.226">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                        <ColumnReference Column="Expr1058" />
                                                                        <ColumnReference Column="Expr1059" />
                                                                      </OutputList>
                                                                      <ComputeScalar>
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1059" />
                                                                            <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0)">
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <RelOp AvgRowSize="65" EstimateCPU="0.237091" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="73724.3" LogicalOp="Right Outer Join" NodeId="18" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="181.224">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                            <ColumnReference Column="Expr1058" />
                                                                          </OutputList>
                                                                          <MemoryFractions Input="1" Output="0.8912" />
                                                                          <Hash>
                                                                            <DefinedValues />
                                                                            <HashKeysBuild>
                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                            </HashKeysBuild>
                                                                            <HashKeysProbe>
                                                                              <ColumnReference Column="Expr1060" />
                                                                            </HashKeysProbe>
                                                                            <ProbeResidual>
                                                                              <ScalarOperator ScalarString="[DWH].[dbo].[CALENDAR].[LB_DAY]=[Expr1060]">
                                                                                <Compare CompareOp="EQ">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Column="Expr1060" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                            </ProbeResidual>
                                                                            <RelOp AvgRowSize="15" EstimateCPU="0.0316451" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Repartition Streams" NodeId="19" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.066385">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                              </OutputList>
                                                                              <Parallelism PartitioningType="Hash">
                                                                                <PartitionColumns>
                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                </PartitionColumns>
                                                                                <RelOp AvgRowSize="15" EstimateCPU="0.00124458" EstimateIO="0.0334954" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Clustered Index Scan" NodeId="20" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0347399" TableCardinality="4383">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                  </OutputList>
                                                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Index="[PK__CALENDAR__E8DA840F11EDDC65]" TableReferenceId="2" IndexKind="Clustered" />
                                                                                  </IndexScan>
                                                                                </RelOp>
                                                                              </Parallelism>
                                                                            </RelOp>
                                                                            <RelOp AvgRowSize="65" EstimateCPU="0.180598" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="73724.3" LogicalOp="Repartition Streams" NodeId="21" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="180.921">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                <ColumnReference Column="Expr1058" />
                                                                                <ColumnReference Column="Expr1060" />
                                                                              </OutputList>
                                                                              <Parallelism PartitioningType="Hash">
                                                                                <PartitionColumns>
                                                                                  <ColumnReference Column="Expr1060" />
                                                                                </PartitionColumns>
                                                                                <RelOp AvgRowSize="76" EstimateCPU="0.260112" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="73724.3" LogicalOp="Compute Scalar" NodeId="22" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="176.63">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                    <ColumnReference Column="Expr1058" />
                                                                                    <ColumnReference Column="Expr1060" />
                                                                                  </OutputList>
                                                                                  <ComputeScalar>
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Column="Expr1058" />
                                                                                        <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]='' THEN NULL ELSE upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]) END">
                                                                                          <IF>
                                                                                            <Condition>
                                                                                              <ScalarOperator>
                                                                                                <Compare CompareOp="EQ">
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="''" />
                                                                                                  </ScalarOperator>
                                                                                                </Compare>
                                                                                              </ScalarOperator>
                                                                                            </Condition>
                                                                                            <Then>
                                                                                              <ScalarOperator>
                                                                                                <Const ConstValue="NULL" />
                                                                                              </ScalarOperator>
                                                                                            </Then>
                                                                                            <Else>
                                                                                              <ScalarOperator>
                                                                                                <Intrinsic FunctionName="upper">
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                </Intrinsic>
                                                                                              </ScalarOperator>
                                                                                            </Else>
                                                                                          </IF>
                                                                                        </ScalarOperator>
                                                                                      </DefinedValue>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Column="Expr1060" />
                                                                                        <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0)">
                                                                                          <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                            <ScalarOperator>
                                                                                              <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </Convert>
                                                                                        </ScalarOperator>
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <RelOp AvgRowSize="46" EstimateCPU="2.86127" EstimateIO="173.509" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="73724.3" LogicalOp="Clustered Index Scan" NodeId="23" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="176.37" TableCardinality="10404500">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                      </OutputList>
                                                                                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                          </DefinedValue>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                          </DefinedValue>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                          </DefinedValue>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <Object Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Index="[PK__DTMPFO_I__191914166C858514]" TableReferenceId="2" IndexKind="Clustered" />
                                                                                        <Predicate>
                                                                                          <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_RENEW_THEO]&gt;='2011-07-01 00:00:00.000' AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_RENEW_THEO]&lt;='2011-07-31 00:00:00.000' AND ([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[STATUS]='D' OR [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[STATUS]='P')">
                                                                                            <Logical Operation="AND">
                                                                                              <ScalarOperator>
                                                                                                <Compare CompareOp="GE">
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_RENEW_THEO" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="'2011-07-01 00:00:00.000'" />
                                                                                                  </ScalarOperator>
                                                                                                </Compare>
                                                                                              </ScalarOperator>
                                                                                              <ScalarOperator>
                                                                                                <Compare CompareOp="LE">
                                                                                                  <ScalarOperator>
                                                                                                    <Identifier>
                                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_RENEW_THEO" />
                                                                                                    </Identifier>
                                                                                                  </ScalarOperator>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="'2011-07-31 00:00:00.000'" />
                                                                                                  </ScalarOperator>
                                                                                                </Compare>
                                                                                              </ScalarOperator>
                                                                                              <ScalarOperator>
                                                                                                <Logical Operation="OR">
                                                                                                  <ScalarOperator>
                                                                                                    <Compare CompareOp="EQ">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="'D'" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                  <ScalarOperator>
                                                                                                    <Compare CompareOp="EQ">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="'P'" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                </Logical>
                                                                                              </ScalarOperator>
                                                                                            </Logical>
                                                                                          </ScalarOperator>
                                                                                        </Predicate>
                                                                                      </IndexScan>
                                                                                    </RelOp>
                                                                                  </ComputeScalar>
                                                                                </RelOp>
                                                                              </Parallelism>
                                                                            </RelOp>
                                                                          </Hash>
                                                                        </RelOp>
                                                                      </ComputeScalar>
                                                                    </RelOp>
                                                                    <Predicate>
                                                                      <ScalarOperator ScalarString="[Expr1058]='47_RNB_A4' OR [Expr1058]='47_RNA_A4' OR [Expr1058]='47_CNA_A4' OR ([Expr1058]='47V_RNB_A4' OR [Expr1058]='47V_RNA_A4' OR [Expr1058]='47V_CNA_A4' OR [Expr1058]='47D_RNB_A4' OR [Expr1058]='47D_RNA_A4' OR [Expr1058]='47D_CNA_A4') AND (CASE WHEN [Expr1059] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&lt;'2010-04-01 00:00:00.000' OR CASE WHEN [Expr1059] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&gt;'2010-04-13 00:00:00.000')">
                                                                        <Logical Operation="OR">
                                                                          <ScalarOperator>
                                                                            <Compare CompareOp="EQ">
                                                                              <ScalarOperator>
                                                                                <Identifier>
                                                                                  <ColumnReference Column="Expr1058" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Const ConstValue="'47_RNB_A4'" />
                                                                              </ScalarOperator>
                                                                            </Compare>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Compare CompareOp="EQ">
                                                                              <ScalarOperator>
                                                                                <Identifier>
                                                                                  <ColumnReference Column="Expr1058" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Const ConstValue="'47_RNA_A4'" />
                                                                              </ScalarOperator>
                                                                            </Compare>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Compare CompareOp="EQ">
                                                                              <ScalarOperator>
                                                                                <Identifier>
                                                                                  <ColumnReference Column="Expr1058" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Const ConstValue="'47_CNA_A4'" />
                                                                              </ScalarOperator>
                                                                            </Compare>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Logical Operation="AND">
                                                                              <ScalarOperator>
                                                                                <Logical Operation="OR">
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47V_RNB_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47V_RNA_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47V_CNA_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47D_RNB_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47D_RNA_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="EQ">
                                                                                      <ScalarOperator>
                                                                                        <Identifier>
                                                                                          <ColumnReference Column="Expr1058" />
                                                                                        </Identifier>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'47D_CNA_A4'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Logical>
                                                                              </ScalarOperator>
                                                                              <ScalarOperator>
                                                                                <Logical Operation="OR">
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="LT">
                                                                                      <ScalarOperator>
                                                                                        <IF>
                                                                                          <Condition>
                                                                                            <ScalarOperator>
                                                                                              <Compare CompareOp="IS">
                                                                                                <ScalarOperator>
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Column="Expr1059" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                                <ScalarOperator>
                                                                                                  <Const ConstValue="NULL" />
                                                                                                </ScalarOperator>
                                                                                              </Compare>
                                                                                            </ScalarOperator>
                                                                                          </Condition>
                                                                                          <Then>
                                                                                            <ScalarOperator>
                                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                    <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </Convert>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </Then>
                                                                                          <Else>
                                                                                            <ScalarOperator>
                                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                    <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </Convert>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </Else>
                                                                                        </IF>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'2010-04-01 00:00:00.000'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Compare CompareOp="GT">
                                                                                      <ScalarOperator>
                                                                                        <IF>
                                                                                          <Condition>
                                                                                            <ScalarOperator>
                                                                                              <Compare CompareOp="IS">
                                                                                                <ScalarOperator>
                                                                                                  <Identifier>
                                                                                                    <ColumnReference Column="Expr1059" />
                                                                                                  </Identifier>
                                                                                                </ScalarOperator>
                                                                                                <ScalarOperator>
                                                                                                  <Const ConstValue="NULL" />
                                                                                                </ScalarOperator>
                                                                                              </Compare>
                                                                                            </ScalarOperator>
                                                                                          </Condition>
                                                                                          <Then>
                                                                                            <ScalarOperator>
                                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                    <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </Convert>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </Then>
                                                                                          <Else>
                                                                                            <ScalarOperator>
                                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                    <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </Convert>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </Else>
                                                                                        </IF>
                                                                                      </ScalarOperator>
                                                                                      <ScalarOperator>
                                                                                        <Const ConstValue="'2010-04-13 00:00:00.000'" />
                                                                                      </ScalarOperator>
                                                                                    </Compare>
                                                                                  </ScalarOperator>
                                                                                </Logical>
                                                                              </ScalarOperator>
                                                                            </Logical>
                                                                          </ScalarOperator>
                                                                        </Logical>
                                                                      </ScalarOperator>
                                                                    </Predicate>
                                                                  </Filter>
                                                                </RelOp>
                                                                <RelOp AvgRowSize="15" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1721.19" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="34" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="5.56971" TableCardinality="2738220">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                  </OutputList>
                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                    <DefinedValues>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                      </DefinedValue>
                                                                      <DefinedValue>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                      </DefinedValue>
                                                                    </DefinedValues>
                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Index="[PK_POLICY]" TableReferenceId="2" IndexKind="Clustered" />
                                                                    <SeekPredicates>
                                                                      <SeekPredicateNew>
                                                                        <SeekKeys>
                                                                          <Prefix ScanType="EQ">
                                                                            <RangeColumns>
                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                            </RangeColumns>
                                                                            <RangeExpressions>
                                                                              <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]">
                                                                                <Identifier>
                                                                                  <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                </Identifier>
                                                                              </ScalarOperator>
                                                                            </RangeExpressions>
                                                                          </Prefix>
                                                                        </SeekKeys>
                                                                      </SeekPredicateNew>
                                                                    </SeekPredicates>
                                                                  </IndexScan>
                                                                </RelOp>
                                                              </NestedLoops>
                                                            </RelOp>
                                                            <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1721.19" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="35" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="5.28653" TableCardinality="2750110">
                                                              <OutputList>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                              </OutputList>
                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Index="[PK_SCHEDULE]" TableReferenceId="2" IndexKind="Clustered" />
                                                                <SeekPredicates>
                                                                  <SeekPredicateNew>
                                                                    <SeekKeys>
                                                                      <Prefix ScanType="EQ">
                                                                        <RangeColumns>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                        </RangeColumns>
                                                                        <RangeExpressions>
                                                                          <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE]">
                                                                            <Identifier>
                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                            </Identifier>
                                                                          </ScalarOperator>
                                                                        </RangeExpressions>
                                                                      </Prefix>
                                                                    </SeekKeys>
                                                                  </SeekPredicateNew>
                                                                </SeekPredicates>
                                                              </IndexScan>
                                                            </RelOp>
                                                          </NestedLoops>
                                                        </RelOp>
                                                      </ComputeScalar>
                                                    </RelOp>
                                                  </Parallelism>
                                                </RelOp>
                                              </Bitmap>
                                            </RelOp>
                                            <RelOp AvgRowSize="167" EstimateCPU="5.13597" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Repartition Streams" NodeId="39" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="216.182">
                                              <OutputList>
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                <ColumnReference Column="Expr1034" />
                                                <ColumnReference Column="Expr1055" />
                                                <ColumnReference Column="Expr1067" />
                                              </OutputList>
                                              <Parallelism PartitioningType="Hash">
                                                <PartitionColumns>
                                                  <ColumnReference Column="Expr1067" />
                                                </PartitionColumns>
                                                <Predicate>
                                                  <ScalarOperator ScalarString="PROBE([Bitmap1083],[Expr1067])">
                                                    <Intrinsic FunctionName="PROBE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Bitmap1083" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1067" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Intrinsic>
                                                  </ScalarOperator>
                                                </Predicate>
                                                <RelOp AvgRowSize="167" EstimateCPU="0.026274" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Compute Scalar" NodeId="40" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="211.046">
                                                  <OutputList>
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                    <ColumnReference Column="Expr1034" />
                                                    <ColumnReference Column="Expr1055" />
                                                    <ColumnReference Column="Expr1067" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1067" />
                                                        <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE] IS NULL AND [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY].[CD_POLICY] THEN [DWH].[dbo].[POLICY].[CD_SCHEDULE] ELSE [DWH].[dbo].[SCHEDULE].[CD_SCHEDULE] END">
                                                          <IF>
                                                            <Condition>
                                                              <ScalarOperator>
                                                                <Logical Operation="AND">
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="IS">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="NULL" />
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </Logical>
                                                              </ScalarOperator>
                                                            </Condition>
                                                            <Then>
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                            </Then>
                                                            <Else>
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                            </Else>
                                                          </IF>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="163" EstimateCPU="12.4837" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Right Outer Join" NodeId="41" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="211.02">
                                                      <OutputList>
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                        <ColumnReference Column="Expr1034" />
                                                        <ColumnReference Column="Expr1055" />
                                                      </OutputList>
                                                      <MemoryFractions Input="0.405907" Output="0.558822" />
                                                      <Hash>
                                                        <DefinedValues />
                                                        <HashKeysBuild>
                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                        </HashKeysBuild>
                                                        <HashKeysProbe>
                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                        </HashKeysProbe>
                                                        <ProbeResidual>
                                                          <ScalarOperator ScalarString="[DWH].[dbo].[SCHEDULE].[CD_SCHEDULE]=[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_SCHEDULE]">
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Identifier>
                                                                  <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                        </ProbeResidual>
                                                        <RelOp AvgRowSize="11" EstimateCPU="1.67599" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2750110" LogicalOp="Repartition Streams" NodeId="42" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="11.8384">
                                                          <OutputList>
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                          </OutputList>
                                                          <Parallelism PartitioningType="Hash">
                                                            <PartitionColumns>
                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                            </PartitionColumns>
                                                            <RelOp AvgRowSize="11" EstimateCPU="0.75632" EstimateIO="9.40609" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2750110" LogicalOp="Clustered Index Scan" NodeId="43" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="10.1624" TableCardinality="2750110">
                                                              <OutputList>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                              </OutputList>
                                                              <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Column="CD_SCHEDULE" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Database="[DWH]" Schema="[dbo]" Table="[SCHEDULE]" Index="[PK_SCHEDULE]" TableReferenceId="1" IndexKind="Clustered" />
                                                              </IndexScan>
                                                            </RelOp>
                                                          </Parallelism>
                                                        </RelOp>
                                                        <RelOp AvgRowSize="159" EstimateCPU="13.0544" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Repartition Streams" NodeId="44" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="186.698">
                                                          <OutputList>
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                            <ColumnReference Column="Expr1034" />
                                                            <ColumnReference Column="Expr1055" />
                                                          </OutputList>
                                                          <Parallelism PartitioningType="Hash">
                                                            <PartitionColumns>
                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                            </PartitionColumns>
                                                            <RelOp AvgRowSize="159" EstimateCPU="7.33092" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Right Outer Join" NodeId="45" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="173.644">
                                                              <OutputList>
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                                <ColumnReference Column="Expr1034" />
                                                                <ColumnReference Column="Expr1055" />
                                                              </OutputList>
                                                              <MemoryFractions Input="0" Output="0" />
                                                              <Hash>
                                                                <DefinedValues />
                                                                <HashKeysBuild>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                </HashKeysBuild>
                                                                <HashKeysProbe>
                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                </HashKeysProbe>
                                                                <ProbeResidual>
                                                                  <ScalarOperator ScalarString="[DWH].[dbo].[POLICY].[CD_PARTNER]=[DWH].[dbo].[PARTNER].[CD_PARTNER]">
                                                                    <Compare CompareOp="EQ">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                    </Compare>
                                                                  </ScalarOperator>
                                                                </ProbeResidual>
                                                                <RelOp AvgRowSize="77" EstimateCPU="0.0287073" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="30" LogicalOp="Distribute Streams" NodeId="46" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0320223">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                                  </OutputList>
                                                                  <Parallelism PartitioningType="Broadcast">
                                                                    <RelOp AvgRowSize="77" EstimateCPU="0.00019" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="30" LogicalOp="Clustered Index Scan" NodeId="47" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.003315" TableCardinality="30">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                                      </OutputList>
                                                                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="CD_PARTNER" />
                                                                          </DefinedValue>
                                                                          <DefinedValue>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Column="LB_PARTNER" />
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <Object Database="[DWH]" Schema="[dbo]" Table="[PARTNER]" Index="[PK_PARTNER]" IndexKind="Clustered" />
                                                                      </IndexScan>
                                                                    </RelOp>
                                                                  </Parallelism>
                                                                </RelOp>
                                                                <RelOp AvgRowSize="93" EstimateCPU="1.2086" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1050960" LogicalOp="Filter" NodeId="48" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="166.281">
                                                                  <OutputList>
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                    <ColumnReference Column="Expr1034" />
                                                                    <ColumnReference Column="Expr1055" />
                                                                  </OutputList>
                                                                  <Filter StartupExpression="false">
                                                                    <RelOp AvgRowSize="93" EstimateCPU="0.08758" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3503200" LogicalOp="Compute Scalar" NodeId="49" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="165.072">
                                                                      <OutputList>
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                        <ColumnReference Column="Expr1034" />
                                                                        <ColumnReference Column="Expr1055" />
                                                                      </OutputList>
                                                                      <ComputeScalar>
                                                                        <DefinedValues>
                                                                          <DefinedValue>
                                                                            <ColumnReference Column="Expr1055" />
                                                                            <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0)">
                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Convert>
                                                                            </ScalarOperator>
                                                                          </DefinedValue>
                                                                        </DefinedValues>
                                                                        <RelOp AvgRowSize="85" EstimateCPU="9.59343" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3503200" LogicalOp="Right Outer Join" NodeId="50" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="164.984">
                                                                          <OutputList>
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                            <ColumnReference Column="Expr1034" />
                                                                          </OutputList>
                                                                          <MemoryFractions Input="0.00677086" Output="0.00932161" />
                                                                          <Hash>
                                                                            <DefinedValues />
                                                                            <HashKeysBuild>
                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                            </HashKeysBuild>
                                                                            <HashKeysProbe>
                                                                              <ColumnReference Column="Expr1056" />
                                                                            </HashKeysProbe>
                                                                            <ProbeResidual>
                                                                              <ScalarOperator ScalarString="[DWH].[dbo].[CALENDAR].[LB_DAY]=[Expr1056]">
                                                                                <Compare CompareOp="EQ">
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                  <ScalarOperator>
                                                                                    <Identifier>
                                                                                      <ColumnReference Column="Expr1056" />
                                                                                    </Identifier>
                                                                                  </ScalarOperator>
                                                                                </Compare>
                                                                              </ScalarOperator>
                                                                            </ProbeResidual>
                                                                            <RelOp AvgRowSize="15" EstimateCPU="0.0316451" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Repartition Streams" NodeId="51" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.066385">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                              </OutputList>
                                                                              <Parallelism PartitioningType="Hash">
                                                                                <PartitionColumns>
                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                </PartitionColumns>
                                                                                <RelOp AvgRowSize="15" EstimateCPU="0.00124458" EstimateIO="0.0334954" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="4383" LogicalOp="Clustered Index Scan" NodeId="52" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0347399" TableCardinality="4383">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                  </OutputList>
                                                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                    <DefinedValues>
                                                                                      <DefinedValue>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                      </DefinedValue>
                                                                                    </DefinedValues>
                                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Index="[PK__CALENDAR__E8DA840F11EDDC65]" TableReferenceId="1" IndexKind="Clustered" />
                                                                                  </IndexScan>
                                                                                </RelOp>
                                                                              </Parallelism>
                                                                            </RelOp>
                                                                            <RelOp AvgRowSize="85" EstimateCPU="10.5795" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3503200" LogicalOp="Repartition Streams" NodeId="53" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="155.325">
                                                                              <OutputList>
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                <ColumnReference Column="Expr1034" />
                                                                                <ColumnReference Column="Expr1056" />
                                                                              </OutputList>
                                                                              <Parallelism PartitioningType="Hash">
                                                                                <PartitionColumns>
                                                                                  <ColumnReference Column="Expr1056" />
                                                                                </PartitionColumns>
                                                                                <RelOp AvgRowSize="85" EstimateCPU="21.5359" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3503200" LogicalOp="Inner Join" NodeId="54" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="144.745">
                                                                                  <OutputList>
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                    <ColumnReference Column="Expr1034" />
                                                                                    <ColumnReference Column="Expr1056" />
                                                                                  </OutputList>
                                                                                  <MemoryFractions Input="0.310575" Output="0.427576" />
                                                                                  <Hash>
                                                                                    <DefinedValues />
                                                                                    <HashKeysBuild>
                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                    </HashKeysBuild>
                                                                                    <HashKeysProbe>
                                                                                      <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                    </HashKeysProbe>
                                                                                    <ProbeResidual>
                                                                                      <ScalarOperator ScalarString="[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY]=[DWH].[dbo].[POLICY_STATUS_ACTUAL].[CD_POLICY]">
                                                                                        <Compare CompareOp="EQ">
                                                                                          <ScalarOperator>
                                                                                            <Identifier>
                                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                            </Identifier>
                                                                                          </ScalarOperator>
                                                                                          <ScalarOperator>
                                                                                            <Identifier>
                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                            </Identifier>
                                                                                          </ScalarOperator>
                                                                                        </Compare>
                                                                                      </ScalarOperator>
                                                                                    </ProbeResidual>
                                                                                    <RelOp AvgRowSize="21" EstimateCPU="9.02687" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834650" LogicalOp="Bitmap Create" NodeId="55" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="81.8765">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                      </OutputList>
                                                                                      <Bitmap>
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Column="Bitmap1082" />
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <HashKeys>
                                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                        </HashKeys>
                                                                                        <RelOp AvgRowSize="21" EstimateCPU="9.02687" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834650" LogicalOp="Inner Join" NodeId="56" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="81.8765">
                                                                                          <OutputList>
                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                          </OutputList>
                                                                                          <MemoryFractions Input="0.584229" Output="0.274236" />
                                                                                          <Hash>
                                                                                            <DefinedValues />
                                                                                            <HashKeysBuild>
                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                            </HashKeysBuild>
                                                                                            <HashKeysProbe>
                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                            </HashKeysProbe>
                                                                                            <RelOp AvgRowSize="11" EstimateCPU="2.89378" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834650" LogicalOp="Bitmap Create" NodeId="57" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="16.0125">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                              </OutputList>
                                                                                              <Bitmap>
                                                                                                <DefinedValues>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Column="Bitmap1081" />
                                                                                                  </DefinedValue>
                                                                                                </DefinedValues>
                                                                                                <HashKeys>
                                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                </HashKeys>
                                                                                                <RelOp AvgRowSize="11" EstimateCPU="2.89378" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834650" LogicalOp="Repartition Streams" NodeId="58" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="16.0125">
                                                                                                  <OutputList>
                                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                  </OutputList>
                                                                                                  <Parallelism PartitioningType="Hash">
                                                                                                    <PartitionColumns>
                                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                    </PartitionColumns>
                                                                                                    <RelOp AvgRowSize="11" EstimateCPU="6.80553" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1834650" LogicalOp="Inner Join" NodeId="59" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="13.1187">
                                                                                                      <OutputList>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                      </OutputList>
                                                                                                      <MemoryFractions Input="0.584811" Output="0.000581971" />
                                                                                                      <Hash>
                                                                                                        <DefinedValues />
                                                                                                        <HashKeysBuild>
                                                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                        </HashKeysBuild>
                                                                                                        <HashKeysProbe>
                                                                                                          <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                                        </HashKeysProbe>
                                                                                                        <ProbeResidual>
                                                                                                          <ScalarOperator ScalarString="[DWH].[dbo].[POLICY_STATUS].[CD_POLICY_STATUS]=[DWH].[dbo].[POLICY_STATUS_ACTUAL].[CD_POLICY_STATUS]">
                                                                                                            <Compare CompareOp="EQ">
                                                                                                              <ScalarOperator>
                                                                                                                <Identifier>
                                                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                                </Identifier>
                                                                                                              </ScalarOperator>
                                                                                                              <ScalarOperator>
                                                                                                                <Identifier>
                                                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                                                </Identifier>
                                                                                                              </ScalarOperator>
                                                                                                            </Compare>
                                                                                                          </ScalarOperator>
                                                                                                        </ProbeResidual>
                                                                                                        <RelOp AvgRowSize="9" EstimateCPU="0.0285226" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13" LogicalOp="Bitmap Create" NodeId="60" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="0.0318189">
                                                                                                          <OutputList>
                                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                          </OutputList>
                                                                                                          <Bitmap>
                                                                                                            <DefinedValues>
                                                                                                              <DefinedValue>
                                                                                                                <ColumnReference Column="Bitmap1080" />
                                                                                                              </DefinedValue>
                                                                                                            </DefinedValues>
                                                                                                            <HashKeys>
                                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                            </HashKeys>
                                                                                                            <RelOp AvgRowSize="9" EstimateCPU="0.0285226" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13" LogicalOp="Distribute Streams" NodeId="61" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0318189">
                                                                                                              <OutputList>
                                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                              </OutputList>
                                                                                                              <Parallelism PartitioningType="Broadcast">
                                                                                                                <RelOp AvgRowSize="9" EstimateCPU="0.0001713" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13" LogicalOp="Clustered Index Seek" NodeId="62" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032963" TableCardinality="14">
                                                                                                                  <OutputList>
                                                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                                  </OutputList>
                                                                                                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                                                                    <DefinedValues>
                                                                                                                      <DefinedValue>
                                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                                      </DefinedValue>
                                                                                                                    </DefinedValues>
                                                                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Index="[PK_POLICY_STATUS]" IndexKind="Clustered" />
                                                                                                                    <SeekPredicates>
                                                                                                                      <SeekPredicateNew>
                                                                                                                        <SeekKeys>
                                                                                                                          <EndRange ScanType="LT">
                                                                                                                            <RangeColumns>
                                                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                                            </RangeColumns>
                                                                                                                            <RangeExpressions>
                                                                                                                              <ScalarOperator ScalarString="'Z'">
                                                                                                                                <Const ConstValue="'Z'" />
                                                                                                                              </ScalarOperator>
                                                                                                                            </RangeExpressions>
                                                                                                                          </EndRange>
                                                                                                                        </SeekKeys>
                                                                                                                      </SeekPredicateNew>
                                                                                                                      <SeekPredicateNew>
                                                                                                                        <SeekKeys>
                                                                                                                          <StartRange ScanType="GT">
                                                                                                                            <RangeColumns>
                                                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS]" Column="CD_POLICY_STATUS" />
                                                                                                                            </RangeColumns>
                                                                                                                            <RangeExpressions>
                                                                                                                              <ScalarOperator ScalarString="'Z'">
                                                                                                                                <Const ConstValue="'Z'" />
                                                                                                                              </ScalarOperator>
                                                                                                                            </RangeExpressions>
                                                                                                                          </StartRange>
                                                                                                                        </SeekKeys>
                                                                                                                      </SeekPredicateNew>
                                                                                                                    </SeekPredicates>
                                                                                                                  </IndexScan>
                                                                                                                </RelOp>
                                                                                                              </Parallelism>
                                                                                                            </RelOp>
                                                                                                          </Bitmap>
                                                                                                        </RelOp>
                                                                                                        <RelOp AvgRowSize="12" EstimateCPU="0.753052" EstimateIO="5.52831" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2738230" LogicalOp="Clustered Index Scan" NodeId="63" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="6.28136" TableCardinality="2738230">
                                                                                                          <OutputList>
                                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                                          </OutputList>
                                                                                                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                                            <DefinedValues>
                                                                                                              <DefinedValue>
                                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY" />
                                                                                                              </DefinedValue>
                                                                                                              <DefinedValue>
                                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                                              </DefinedValue>
                                                                                                            </DefinedValues>
                                                                                                            <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Index="[PK__POLICY_STATUS_AC__43ECB87E]" IndexKind="Clustered" />
                                                                                                            <Predicate>
                                                                                                              <ScalarOperator ScalarString="PROBE([Bitmap1080],[DWH].[dbo].[POLICY_STATUS_ACTUAL].[CD_POLICY_STATUS])">
                                                                                                                <Intrinsic FunctionName="PROBE">
                                                                                                                  <ScalarOperator>
                                                                                                                    <Identifier>
                                                                                                                      <ColumnReference Column="Bitmap1080" />
                                                                                                                    </Identifier>
                                                                                                                  </ScalarOperator>
                                                                                                                  <ScalarOperator>
                                                                                                                    <Identifier>
                                                                                                                      <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY_STATUS_ACTUAL]" Column="CD_POLICY_STATUS" />
                                                                                                                    </Identifier>
                                                                                                                  </ScalarOperator>
                                                                                                                </Intrinsic>
                                                                                                              </ScalarOperator>
                                                                                                            </Predicate>
                                                                                                          </IndexScan>
                                                                                                        </RelOp>
                                                                                                      </Hash>
                                                                                                    </RelOp>
                                                                                                  </Parallelism>
                                                                                                </RelOp>
                                                                                              </Bitmap>
                                                                                            </RelOp>
                                                                                            <RelOp AvgRowSize="17" EstimateCPU="2.61355" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2738220" LogicalOp="Repartition Streams" NodeId="65" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="56.8371">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                                <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                              </OutputList>
                                                                                              <Parallelism PartitioningType="Hash">
                                                                                                <PartitionColumns>
                                                                                                  <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                                </PartitionColumns>
                                                                                                <RelOp AvgRowSize="17" EstimateCPU="0.753048" EstimateIO="53.4705" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2738220" LogicalOp="Clustered Index Scan" NodeId="66" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="54.2236" TableCardinality="2738220">
                                                                                                  <OutputList>
                                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                                    <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                                  </OutputList>
                                                                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                                                                    <DefinedValues>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                                      </DefinedValue>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_PARTNER" />
                                                                                                      </DefinedValue>
                                                                                                      <DefinedValue>
                                                                                                        <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_SCHEDULE" />
                                                                                                      </DefinedValue>
                                                                                                    </DefinedValues>
                                                                                                    <Object Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Index="[PK_POLICY]" TableReferenceId="1" IndexKind="Clustered" />
                                                                                                    <Predicate>
                                                                                                      <ScalarOperator ScalarString="PROBE([Bitmap1081],[DWH].[dbo].[POLICY].[CD_POLICY],N'[IN ROW]')">
                                                                                                        <Intrinsic FunctionName="PROBE">
                                                                                                          <ScalarOperator>
                                                                                                            <Identifier>
                                                                                                              <ColumnReference Column="Bitmap1081" />
                                                                                                            </Identifier>
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator>
                                                                                                            <Identifier>
                                                                                                              <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[POLICY]" Column="CD_POLICY" />
                                                                                                            </Identifier>
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator>
                                                                                                            <Const ConstValue="N'[IN ROW]'" />
                                                                                                          </ScalarOperator>
                                                                                                        </Intrinsic>
                                                                                                      </ScalarOperator>
                                                                                                    </Predicate>
                                                                                                  </IndexScan>
                                                                                                </RelOp>
                                                                                              </Parallelism>
                                                                                            </RelOp>
                                                                                          </Hash>
                                                                                        </RelOp>
                                                                                      </Bitmap>
                                                                                    </RelOp>
                                                                                    <RelOp AvgRowSize="74" EstimateCPU="0.133401" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5336040" LogicalOp="Compute Scalar" NodeId="68" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="41.3327">
                                                                                      <OutputList>
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                        <ColumnReference Column="Expr1034" />
                                                                                        <ColumnReference Column="Expr1056" />
                                                                                      </OutputList>
                                                                                      <ComputeScalar>
                                                                                        <DefinedValues>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Column="Expr1034" />
                                                                                            <ScalarOperator ScalarString="CASE WHEN [DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]='' THEN NULL ELSE upper([DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[LETTER_NAME]) END">
                                                                                              <IF>
                                                                                                <Condition>
                                                                                                  <ScalarOperator>
                                                                                                    <Compare CompareOp="EQ">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="''" />
                                                                                                      </ScalarOperator>
                                                                                                    </Compare>
                                                                                                  </ScalarOperator>
                                                                                                </Condition>
                                                                                                <Then>
                                                                                                  <ScalarOperator>
                                                                                                    <Const ConstValue="NULL" />
                                                                                                  </ScalarOperator>
                                                                                                </Then>
                                                                                                <Else>
                                                                                                  <ScalarOperator>
                                                                                                    <Intrinsic FunctionName="upper">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                    </Intrinsic>
                                                                                                  </ScalarOperator>
                                                                                                </Else>
                                                                                              </IF>
                                                                                            </ScalarOperator>
                                                                                          </DefinedValue>
                                                                                          <DefinedValue>
                                                                                            <ColumnReference Column="Expr1056" />
                                                                                            <ScalarOperator ScalarString="CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0)">
                                                                                              <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                                <ScalarOperator>
                                                                                                  <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                                    <ScalarOperator>
                                                                                                      <Identifier>
                                                                                                        <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                      </Identifier>
                                                                                                    </ScalarOperator>
                                                                                                  </Convert>
                                                                                                </ScalarOperator>
                                                                                              </Convert>
                                                                                            </ScalarOperator>
                                                                                          </DefinedValue>
                                                                                        </DefinedValues>
                                                                                        <RelOp AvgRowSize="44" EstimateCPU="9.4843" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5336040" LogicalOp="Repartition Streams" NodeId="69" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="41.1993">
                                                                                          <OutputList>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                          </OutputList>
                                                                                          <Parallelism PartitioningType="Hash">
                                                                                            <PartitionColumns>
                                                                                              <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                            </PartitionColumns>
                                                                                            <RelOp AvgRowSize="44" EstimateCPU="1.46745" EstimateIO="30.2476" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5336040" LogicalOp="Index Seek" NodeId="70" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="31.715" TableCardinality="10404500">
                                                                                              <OutputList>
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                              </OutputList>
                                                                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                                                                                <DefinedValues>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                                  </DefinedValue>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                  </DefinedValue>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                                  </DefinedValue>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_SCHEDULE" />
                                                                                                  </DefinedValue>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_NAME" />
                                                                                                  </DefinedValue>
                                                                                                  <DefinedValue>
                                                                                                    <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="FG_RENEW" />
                                                                                                  </DefinedValue>
                                                                                                </DefinedValues>
                                                                                                <Object Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Index="[IDX_DTMPFO_IMPRESSIONS__LETTER_TYPE__STATUS]" TableReferenceId="1" IndexKind="NonClustered" />
                                                                                                <SeekPredicates>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'CN1'">
                                                                                                            <Const ConstValue="'CN1'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'D'">
                                                                                                            <Const ConstValue="'D'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'CN1'">
                                                                                                            <Const ConstValue="'CN1'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'P'">
                                                                                                            <Const ConstValue="'P'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN1'">
                                                                                                            <Const ConstValue="'RN1'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'D'">
                                                                                                            <Const ConstValue="'D'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN1'">
                                                                                                            <Const ConstValue="'RN1'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'P'">
                                                                                                            <Const ConstValue="'P'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN2'">
                                                                                                            <Const ConstValue="'RN2'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'D'">
                                                                                                            <Const ConstValue="'D'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN2'">
                                                                                                            <Const ConstValue="'RN2'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'P'">
                                                                                                            <Const ConstValue="'P'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN3'">
                                                                                                            <Const ConstValue="'RN3'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'D'">
                                                                                                            <Const ConstValue="'D'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                  <SeekPredicateNew>
                                                                                                    <SeekKeys>
                                                                                                      <Prefix ScanType="EQ">
                                                                                                        <RangeColumns>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="LETTER_TYPE" />
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="STATUS" />
                                                                                                        </RangeColumns>
                                                                                                        <RangeExpressions>
                                                                                                          <ScalarOperator ScalarString="'RN3'">
                                                                                                            <Const ConstValue="'RN3'" />
                                                                                                          </ScalarOperator>
                                                                                                          <ScalarOperator ScalarString="'P'">
                                                                                                            <Const ConstValue="'P'" />
                                                                                                          </ScalarOperator>
                                                                                                        </RangeExpressions>
                                                                                                      </Prefix>
                                                                                                    </SeekKeys>
                                                                                                  </SeekPredicateNew>
                                                                                                </SeekPredicates>
                                                                                                <Predicate>
                                                                                                  <ScalarOperator ScalarString="PROBE([Bitmap1082],[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[CD_POLICY],N'[IN ROW]')">
                                                                                                    <Intrinsic FunctionName="PROBE">
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Column="Bitmap1082" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Identifier>
                                                                                                          <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="CD_POLICY" />
                                                                                                        </Identifier>
                                                                                                      </ScalarOperator>
                                                                                                      <ScalarOperator>
                                                                                                        <Const ConstValue="N'[IN ROW]'" />
                                                                                                      </ScalarOperator>
                                                                                                    </Intrinsic>
                                                                                                  </ScalarOperator>
                                                                                                </Predicate>
                                                                                              </IndexScan>
                                                                                            </RelOp>
                                                                                          </Parallelism>
                                                                                        </RelOp>
                                                                                      </ComputeScalar>
                                                                                    </RelOp>
                                                                                  </Hash>
                                                                                </RelOp>
                                                                              </Parallelism>
                                                                            </RelOp>
                                                                          </Hash>
                                                                        </RelOp>
                                                                      </ComputeScalar>
                                                                    </RelOp>
                                                                    <Predicate>
                                                                      <ScalarOperator ScalarString="CASE WHEN [Expr1055] IS NULL THEN CONVERT(datetime,CONVERT(varchar(10),[DTMPFO].[dbo].[DTMPFO_IMPRESSIONS].[DT_REQUEST],112),0) ELSE CONVERT(datetime,CONVERT(varchar(10),[DWH].[dbo].[CALENDAR].[LB_DAY],112),0) END&gt;='2011-02-01 00:00:00.000'">
                                                                        <Compare CompareOp="GE">
                                                                          <ScalarOperator>
                                                                            <IF>
                                                                              <Condition>
                                                                                <ScalarOperator>
                                                                                  <Compare CompareOp="IS">
                                                                                    <ScalarOperator>
                                                                                      <Identifier>
                                                                                        <ColumnReference Column="Expr1055" />
                                                                                      </Identifier>
                                                                                    </ScalarOperator>
                                                                                    <ScalarOperator>
                                                                                      <Const ConstValue="NULL" />
                                                                                    </ScalarOperator>
                                                                                  </Compare>
                                                                                </ScalarOperator>
                                                                              </Condition>
                                                                              <Then>
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                        <ScalarOperator>
                                                                                          <Identifier>
                                                                                            <ColumnReference Database="[DTMPFO]" Schema="[dbo]" Table="[DTMPFO_IMPRESSIONS]" Column="DT_REQUEST" />
                                                                                          </Identifier>
                                                                                        </ScalarOperator>
                                                                                      </Convert>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Then>
                                                                              <Else>
                                                                                <ScalarOperator>
                                                                                  <Convert DataType="datetime" Style="0" Implicit="false">
                                                                                    <ScalarOperator>
                                                                                      <Convert DataType="varchar" Length="10" Style="112" Implicit="false">
                                                                                        <ScalarOperator>
                                                                                          <Identifier>
                                                                                            <ColumnReference Database="[DWH]" Schema="[dbo]" Table="[CALENDAR]" Column="LB_DAY" />
                                                                                          </Identifier>
                                                                                        </ScalarOperator>
                                                                                      </Convert>
                                                                                    </ScalarOperator>
                                                                                  </Convert>
                                                                                </ScalarOperator>
                                                                              </Else>
                                                                            </IF>
                                                                          </ScalarOperator>
                                                                          <ScalarOperator>
                                                                            <Const ConstValue="'2011-02-01 00:00:00.000'" />
                                                                          </ScalarOperator>
                                                                        </Compare>
                                                                      </ScalarOperator>
                                                                    </Predicate>
                                                                  </Filter>
                                                                </RelOp>
                                                              </Hash>
                                                            </RelOp>
                                                          </Parallelism>
                                                        </RelOp>
                                                      </Hash>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                              </Parallelism>
                                            </RelOp>
                                          </Hash>
                                        </RelOp>
                                      </ComputeScalar>
                                    </RelOp>
                                  </Parallelism>
                                </RelOp>
                              </Sort>
                            </RelOp>
                          </StreamAggregate>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                    <Predicate>
                      <ScalarOperator ScalarString="[Expr1037]=(1)">
                        <Compare CompareOp="EQ">
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Column="Expr1037" />
                            </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Const ConstValue="(1)" />
                          </ScalarOperator>
                        </Compare>
                      </ScalarOperator>
                    </Predicate>
                  </Filter>
                </RelOp>
              </Parallelism>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>