Page 1 of 1

Cross Table Analysis based on Key columns

Posted: Tue Jan 27, 2009 1:56 am
by wfis
Hi,


Can someone suggest how do we go about performing cross table analysis based on key columns that match across tables.

To be more clear, I want to analyze a particular column from one table by performing equi join on the key columns from both the tables.


Kindly help.

Posted: Tue Jan 27, 2009 3:13 am
by ray.wurlod
Candidate keys have already identified. You choose the ones you want investigated for foreign key/primary key relationships from the list presented to you. The remainder of cross table analysis verifies (or not) whether the suggested keys are valid to identify such a relationship.