- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Geeky table/normalization question for BI Developers
Posted on 2/4/15 at 6:02 pm
Posted on 2/4/15 at 6:02 pm
If presented with a source 3NF data model that consisted of customer, order header, order line, and product tables and a dimensional target model consisting of customer and product dimensions and an order fact; how would you go about reconciling the target to the source?
Posted on 2/4/15 at 6:35 pm to TROCKS50
What do you mean when you say 'reconciling' the target to source? Are you trying to make sure all products and customers are accounted for as members in the respective dimensions?
Posted on 2/4/15 at 6:54 pm to Brisketeer
Are you trying to make sure all products and customers are accounted for as members in the respective dimensions?
Yes
Yes
Posted on 2/5/15 at 8:24 am to TROCKS50
Assuming these are standard dimensions (not SCD), I truncate and rebuild the dimension tables each time I process. This is the most efficient way to ensure all dimension members are accounted for. Incremental updates can get very messy.
After you build the dimension table, you can compare the row counts (using primary key) to validate that all members are present.
After you build the dimension table, you can compare the row counts (using primary key) to validate that all members are present.
Popular
Back to top
Follow TigerDroppings for LSU Football News