Q: What are some best practices for validating data in staging tables after the ETL process has moved the data from the source to the warehouse staging tables?
I personally don't like to validate during the move from source to staging tables. I prefer to download the data as fast as possible so not to "bother" the source system. From there, I do all the cleansing and transforming.
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