HARMAN interview question

joins , windows function, scenarios based question on talend as well as sql