Tag Info

New answers tagged

0

These are general recommendations, as you do not show the full extent of your queries to be performed (which kind of analytics you plan to do). Assuming you do not need real time results, you should just denormalize your data at the end of the period, precalculate once your aggregated results on all necessary timeframes -by day, by week, by month-, and work ...


0

These are the hints: The dimension consists only of natural key (e.g. invoive's or order's number) and contains no other attributes (because they've been placed in dimensions of their own). The dimension table grows proportionately with the fact table, e.g. every time you insert new order lines into the fact table, you have to insert new OrderNumber ...


0

My understanding is you use a Degenerate Dimension when it has an outside reference to something that people may want to search on, which could be an operational system or outside the organisation reference. It is useful for the business people to see, usually because it links to something they know (another system or outside reference), so it is included. ...


0

Not really. Fact tables has rows which are a intersection of all the joined dimensions. Joining a fact table to another fact table doesn't really make sense - two facts should be joined through a conformed dimension. I don't consider it acceptable. No. Measures quantify the intersection of all the dimensions, they enable you to measure that item not change ...


0

You don't need Oracle Warehouse Builder (OWB) to implement a data-warehouse. I'd prefer to do it in PL/SQL, with as much in pure SQL as possible. In Oracle 12 you can even submit blocks of PL/SQL to the SQL engine for execution, avoiding the traditional row-by-row context switch that was needed in the past. OWB doesn't use many features of the DBMS that ...


0

The IRI Workbench (Eclipse GUI) supports bulk (multi-table) extraction, mapping (transformations, if needed, with rules), and bcp loads; specifically, its' reorg wizard is mentioned here. I wouldn't start with 200 sources at once, but see how it goes for the first 10 to determine if its multi-script approach (which I like for portability and easy ...


0

Depending on the volume, if you use an affordable high-speed tool for data integration like IRI CoSort (which can use either bulk-extracted/loaded flat-file data or ODBC connections), you'll be near real-time anyway (with its speed, and without in-DB transforms). To be closer to real time per the article, you can 'regulate flow' via CDC in a data- (rather ...


0

It's also a matter of money. Where data volumes are high as you point out, flat-file based solutions like Ab Initio and DataStage Parallel Extender are indeed faster, but can be mid-to-high six-figure propositions. IRI CoSort is very ETL-centric (per their ELT comparison), and the only affordable way I've seen to address the transformation volume with ...



Top 50 recent answers are included