Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Warehouse builder subqueries in joiner

Status
Not open for further replies.
Joined
Mar 30, 2001
Messages
6
Location
GB
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!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top