How do you people test business logic in ETL pipelines?..
Checking nulls, duplicates, row counts ...is kinda of straightforward....
But what about actual business rules!
Like revenue should be calculated in a certain way, some records should be excluded, dates should follow some rule and more....
Do you guys keep these as separate tests or validate them as part of the ETL itself or any....
Curious how people do actually handle this in real projects.