SCD or data in FACT TABLE

Hi,

We have certain codes (dimensions) that have expiration date.
In my opinion, these are the scd dimensions. The FACT table
would be based on the foreign key, and get a real date information.
And also this will help as to trace the history.
Now associate wants that dimenzion table do not need the expiration date
and through field (fk) in the FACT table we will know the real codes that
hapened in the time when transection appears.

Is that realy the right way, what is your opinion, thanks in advance, Km

It depends on the business. I have seen some source tables where they had effective dates and seemed type 2 but were not because the most recent record better describes all the data even in the past, so , in that case I was able to keep it a type 1. In another case I was not able to because for anything that is NOT the FK and changed, it would update, therefore saying something that was NOT true at the time of the past event and in this case I want a type 2...but even in other cases I was able to take a source table and split some of it into facts to keep the dimension a type 1 and have the ETL logic write the fields to the fact table and supply the correct FK from the dimension to the fact.

Thanks for all explanation. This will help me,

Best regard, K