Weak convergence of delay SDEs with applications to Carathéodory approximation