Hi ! ! !  I am an BI Lead by Profession. What I like about being part of IT industry is "bright side of the scariest part". Yes, you guessed it right, its job insecurity :) . Bright side to this part is eternal conquest for improvement. Thrill of overcoming a challenge cannot be put in words. In this post I am going to share something similar with readers. Other day, I was hanging out with my pack and one person came up with weird requirement that she faced as an Interview question. I came up with a solution to her problem, sharing the same with you.  Do let know if you liked it or if you have some suggestions to enhance the same or in case you have some queries that I should answer. Hope you like it. Assumptions: I expect readers of this post are already aware of SQL & ODI environment and know how to create topology connections for the same. I expect we are using Oracle Database for exercise. Disclaimer: Source system type columns name and subject area of...