Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 05 Jun 2005 @ 22:34:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: V2R5.1 dynamic partition elimination
From:   Wayne Schachtel

I posted the queries/questions. What I was trying to do was get DPE to work with simple inner join logic.

In V2R5.1 - the partitioning value must be explicit supplied. Using a date data type as an example - '2005-12-01', cast('2005-01-01" as date), cast(:date_var as date format 'YYYY-MM-DD') will work. I've verified this does work in V2R5.1.

What does not work, but supposedly does work in V2R6.X is DPE based on inner join logic.

Assume fact table is partitioned on per_id, dimenison table has PI on per_id and user enters a date value as a run-time parameter. The following should work in V2R6.X, I have not verified this -

     Select b.cal_date, a.fact_col1, . . .
       from fact_table a
        join dim_time   b
          on a.per_id = b.per_id
     where b.cal_date = cast(:date_var as date format 'YYYY-MM-DD');

If anyone can respond who has access to a V2R6.X system; we'd all appreciate it.

Wayne Schachtel
Wayne Schachtel Consulting

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023