REQUIREMENTS FOR HASHING
Traditional data warehouses often use sequence numbers to identify records in other tables.
By using sequences, this method comes with some drawbacks. One of the biggest drawbacks is performance. Since the sequence numbers are generated by a generator, this step presents a bottleneck. In addition sequence numbers are generated in the data warehouse instead of loading them before.
This solution provides a template and the requirements round about hashing.