Hi All,

I am creating Sales analysis OLAP where the transaction is in different
currency while the analysis must be done in local currency.
Since the exchange rate fluctuates, I dont want to update fact table every
time the rate changes, so I decided to use VIEW as Fact table,
Joining transaction table and the monthly_currency_rate table .

Can any body tell me how is performance drawbacks to be considered here ?
about using VIEW as facttable ?

Thank you for your help,
Krist

"tristant" <krislioe (AT) cbn (DOT) net.id> wrote