Hello,
In my RPD, I have a fact table with a DATE column which also contains a time component. The physical layer shows this as a DATETIME column which I changed to DATE since I am only interested in the date part.
When I join this to an alias of my Date dimension, the physical sql generated is similar to:
DIM_DATE.DATE = FACT_A.FINISH_DATE
What I actually want is :
DIM_DATE.DATE = TRUNC(FACT_A.FINISH_DATE)
How can I achieve this at the RPD level? Yes, I can add a new column to the DW table with truncated value, but I want to know why even if I selected DATE as the datatype in the RPD, the join created does not do a trunc.
Thanks,
Manish