More than one join in a data rule

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

Moderators: chulett, rschirm

Post Reply
shails
Participant
Posts: 27
Joined: Mon Jul 18, 2005 2:55 am

More than one join in a data rule

Post by shails »

Hi,
Can 3 tables be joined together in one data rule as below.

TableA_colB in_reference_column TableB_colB
AND TableA_colC in_reference_column TableC_colC

If I do the joins individually in 2 different data rules I am getting correct result but when I use a AND condition and try to do the joins together in one data rule I am seeing zero records as output which is not correct.
Thanks.
Top
Derrickfn
Participant
Posts: 11
Joined: Fri Jul 18, 2008 4:07 pm
Location: Alexandria

Post by Derrickfn »

Are you sure there is an intersection between the data results between TableA_ColB and TableA_ColC? Could you please post the actual rule logic. Are any of the fields nullable?
Top
Post Reply

Return to “Information Analyzer (formerly ProfileStage)”