Warehouse builder subqueries in joiner

[nathanjones]

Hi All,

I'm starting developing a datamart using oracle warehouse builder and as part of the dimension processing i need to check the incoming values of a dimension against the current version of the dimension. To do this I want to create a 'not in' subquery to check say the client code, probably in a joiner operator.

A typical example is (using client_stage(incoming) and client_master(current))

<where>
cl.client_code not in (select cm.client_code from client_master)

cl and cm are the input groups into the joiner operator for client_stage and client_master respectively.

If I use client_master as above, the validation fails with the error 'client_master is not declared'

Any help would be much appreciated. It seems as if this is a fundamental part of OWB but I can't seem to get it working

Thanks in advance, Nathan

ps I haven't had any formal training on the product so if this is really basic pls forgive me!!!