I've been modeling data ad-hoc for a few years now, I'm curious dilettante, no expert. I've recently found myself the Data Engineer for a mid-sized financial company, tasked with building Data Marts for self-reporting.
I've been given a design spec that includes complex db Views. The Wizard doesn't render views (as previously noted) so I've built them as Entities, marking them with their own "View" category. Now I'm integrating one of them into the larger model (snowflake fact with mostly dimension tables, one dbo.category table and 2 views)
The Views have no indexes or keys. The joins are semi-complex, joining to the fact table with a WHERE clause with conditions.
Question: How do I model this in Toad Data Modeler? The Relationship Properties (RP) works well with defined PK and FK's but not with less structured join conditions. The RP General tab Parent/Child box is empty with no method to create user-defined joins or more complex WHERE clauses. ----at least that I've discovered.
I'm not finding any clues in the Forums or google in general. I'm hoping some experts here will enlighten me.
Thank you for your time.