Longer Change Log than data target
I have one ODS and only van data target from this ODS. The change-log table of this ODS contains 120 million records, but the data target cube (which get data from another ODS) only 43 million. Why? How can I reduce the size of change log table (now more than 150 GB!)?
Thanks for your helps