Skip to Content
Oct 09, 2019 at 08:50 PM

Advanced Join Properties in IDT

147 Views Last edit Oct 09, 2019 at 08:51 PM 2 rev


I am trying to find where to set "Advanced Join Properties" in IDT. My goal is to apply some conditions in WHERE clause and some conditions in FROM clause. After I changed ANSI92 and FILTER_IN_FROM to Yes, I could not find where to Select Objects to be applied in FROM clause (i.e., PFA image).

I can get to the Advanced Join Properties in UDT and not sure how to get to that screen in IDT.

I am using Information Design Tool 4.2 (not sure about the Service Pack/Patch).

Single Source Universe with Oracle 11g Database.

Any help is appreciated.

Thank you,