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

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