Can we omit duplicate records using the Aggregate Transformation in Astera Centerprise?

No, but Astera Centerprise has a dedicated Distinct Transformation to filter out duplicate records from a dataset.