Archives of the TeradataForum

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

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

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>>