ODI Real time Scenario's and Interview Questions

 Source: Expected Output: Query: Script: with sample as ( select 1 col1,'a' col2 from dual union select 2 col1,'b' col2 from...

 Given following set of integers, write an SQL statement to determine the expected outputs: Source : Expected Output: Source: Output: Script...

 You work for a software company that released a 2-player game and you need to tally the scores. Given the following table , write a SQL sta...

 Your process log has several workflows broken step by numbers with the possible status values of Complete , Running or Error. Your task is ...

      You can work for manufacturing company and need to track inventory adjustments from the warehouse. Some days inventory increases, on o...

 Your Customer phone directory table allows individuals to setup a home, cellular, or a work phone number. Write a SQL statement to transfor...

 Write an SQL statement given the following requirements. For every customer that had a delivery to Hyderabad, provide a result set of the c...