Trying to predict sales from demographics

[dba]

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!

[Dejan Sarka]

Post by dba
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.