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

Don't have an account? Register for Free Unlimited Access