DW lookup - I want to lookup in the target DB (not source)

[Pierre_G]

I want to map a column using a lookup to a view column located in the DW (not in the source). The GUI does allow the Data Warehouse to be selected as a source for the lookup. Please advise.

[shashi_holla · Accepted solution]

Hi @Pierre_G 

This is just a theory and I haven't tried it. Can we create new Source connection pointing to the DW database and then we should be able to query the data from there. 

Please try and let us know.

Thank you,

[Pierre_G]

Hello @shashi_holla . Thanks for the fast reply. I have tested your solution and it is working. Thanks!

[shashi_holla]

Great, Thanks for the confirmation @Pierre_G