Use Temp Interface as Derived Table (Sub-Select) checkbox is not enabled
835246Jul 25 2012 — edited Nov 8 2012All,
I created a yellow interface using union all (2 data sets) and i am using this yellow interface as source in a new interface.
Use Temporary Interface as Derived Table (Sub-Select) checkbox is not enabled when i click on this yellow interface?
Do i need to do some settings in Technology? i am using ODI 11.1.1.3 version.
query is something like below:
select col1,col2,... from (select col1,col2 from table1 unionall select col1,col2 from table2) inner join table3.
Please help me... thanks in advance.