Trying to predict sales from demographics

Hello all,

Sorry for a beginner question, I have one table with demographics,
I have another table with sales. I want to figure out which
demographics most likely result in a sale. Now, as an input it seems
to only want to use just one table. Can I use a view, which will
involve a lot of tables and I'm afraid that it may affect the
cardinality. Maybe I'm doing something wrong not sure, any advise
appreciated!

Thanks!

> Sorry for a beginner question, I have one table with demographics,
> I have another table with sales. I want to figure out which
> demographics most likely result in a sale. Now, as an input it seems
> to only want to use just one table. Can I use a view, which will
> involve a lot of tables and I'm afraid that it may affect the
> cardinality. Maybe I'm doing something wrong not sure, any advise
> appreciated!

You can use a view to join the demographic data with sales data; however, as
you said, you would affect cardinality of your demographic data. You can use
nested table instead - declare demographic table as case table and sales
table as nested table. There is also another possibility, if you are
interested in total sales only. Then you can create a view that would
combine demographic data with sales aggregations.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx