Can we perform a hierarchical join using the Join transformation in Centerprise?

No, we cannot. The Join transformation can only be used to join flat file formats. However, there is a dedicated transformation, the Tree Join transformation in Astera Centerprise which you can use to perform hierarchical joins in Astera Centerprise.