Question:When extracting daily from a source table that does not maintain history, should the DW (normalized model, not mart) use current day as the effective date (YMD), date time, a day or day time for the actual extract day (see note below) or a modified date on the source record? Do we use a date or a date and time?
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access