Continuous development of infrastructure consumes huge amounts of non-renewable materials, which is affecting the ecosystem. The swapping of industrial waste with non-renewable materials is one of the promising ways to promote sustainable development. Ceramic waste (CW) when processed suitably have physical properties very similar to conventional fine aggregate. Hence, this study thus investigates the performance of OPC and PPC-based mortar containing up to 80% CW as swapping of fine aggregate. The variation in water requirement and compressive strength was recorded. Results revealed that water demand reduced on addition of up to 50% CW in OPC based mortar which indicated the better flow ability of formed mortar composite. Moreover, strength was found to be increased on addition of up to 40% CW after that decrease in strength was monitored. All the PPC based mortar containing up to 80% CW exhibited lower water demand and higher compressive strength. Besides, PPC based mortar containing 40% CW exhibited similar strength as compared to OPC based control mixture. It is concluded that PPC based mortar containing CW can be formed with similar flow ability and strength compared to OPC based mortar. This can lead to reduced dependency on the scarcest river sand and improve the useability of PPC mortars which conventionally has lower compressive strength when compared to OPC mortars.