In source table
Customer ID Gender
1 M
2 F
3 F
4 M
5 F
Target:
Customer ID Gender
1 F
2 M
3 M
4 F
5 M
i have one source and target table and Gender in source table is transformed into target table
e.g. M in source is F in traget
How can i validate transformation logic from source to target table
can someone please guide
tried minus query but not sure about transformation condition
New contributor
Aastha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1