Debugged the step in the i0160 ETL which updates the isdept of the SAP_Hierarchy based on the INVDPT value. Analyzed the queries and the steps. Solved the issue of hierarchy not updating due to the data from SAP_Hierarchy and INVDPT not merging.