complete data transformation spec