I have a table which is joined to the fact table on Column 'X'. And the Primary key of the table is 'X'.
After I have done the hash partitioning on X, the record count from the query on the Analytic View is reducing.
Couldn't able to paste the code/ write the exact names here as the names have sensitive information.
Any thoughts on this?