How can a technical consultant organize multiple records with the same Effective From Date into one Fact Table record?
Use a calculated column called Effective Sequence.
Use the Effective Sequence Special Use Type on a numeric field.
Use a calculated column to filter unwanted records.
Use the To Date Special Use Type on a date field.
Submit