I am having a 300 lines of SQL(Oracle), which is joining 36 tables altogether in the same SQL.
Ex:
Select c1.a, c2.b
from c1,c2
where c1.a in
( select b1.a
from b1,b2
where b1.a in
(
select a1.a
from a1,a2
where a1.a in
(
.......
)
)
)
, like that , It is something like inline views in oracle kinda. can anyone let me know what is the bestway to implement the similar logic using Datastage.
>
I just want to simulate the same in Datastage instead of pasting big SQL in one Oracle query
![Smile :)](./images/smilies/icon_smile.gif)
Please throw your views on this.
Thanks.
friend.kak@gmail.com