Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have the below table
FACT:
LOAD
[Effective Date From],[Customer SK],[Risk] from Fact.qvd(qvd)
this table contain customer key and the risk rate for this customer from a certain date let's say 01/11/2021
in my Data Model I need this table to be by day and to have the same row duplicated from the effective date from (01/11/2021) till today 08/11/2021 so in this case I will have 9 rows and will help me better in the way I am building my schema.
Thanks.
Have a look at past questions of the same nature (perhaps replacing the to_date with today()):
Have a look at past questions of the same nature (perhaps replacing the to_date with today()):