Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

This diagram outlines the data flows as we understand them between the National Data Warehouse (NDW) and Intrepid. The diagram shows Phase 1, (rebase enabled) which exists up until all Local Offices have implemented onto TIS, Phase 2 begins when we disable the TIS inbound ETL and enable the outbound to Intrepid.

Note Phase 2 evolved through iterative design, specifically to simplify the Intrepid-NDW flows.


TIS - Intrepid Data Flows V1.2.pptx




NDW detailed design

A more detailed design of the Intrepid-NDW ETL and how the TIS-NDW ETL is consumed by the NDW can be found in this design and diagram from John Thompson - this is a static copy from  - please refer to John Thompson for updates.


DR2 Tables to NDW - part 1 spec.xlsx


  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.