additionally, in the cognos sql, you will find the key words:
coalesce
(...
)
full outer join
(..
)
if you are seeing stitched queries, then i would say your model design is good as it would seem that you are follwoing best pratices.. as JGirl said, why would you want to remove them?