Implement antijoin in OBIEE

Question

I have data in 2 tables and need to implement antijoin between them in OBIEE11/12c. Please suggest how should I model my repository.

Thanks

Viresh

Martin van Donselaar · Answer

Is this something you need for just one or few analyses?

If so you may also consider to use sub-queries in your analyses instead of fixing it in your model (which shouldn't be overly complex IMO).

Gianni Ceresa · Answer

You can try with table1 left outer join table2 and a condition to keep only rows where table1.column is null .

That's one of the way to do it in SQL and you can do it in the LTS.