Virtual table as reference data for IN_REFERENCE_COLUMN chec

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Virtual table as reference data for IN_REFERENCE_COLUMN chec

Post by U »

Is it possible to use an IA virtual table (a three-way join of source data tables) to provide the reference column for an IN_REFERENCE_COLUMN check?

Would the performance of such an approach be better than, or worse than, doing the same join in a view in the source database (which happens to be Netezza)?

Thank you again for your time.
Post Reply